How to dump XML files to SQL Server using Script Task?

  • Hi – I have come across with an issue in my project where source is XML files stay in some remote server and I would require them to dump into SQL Server table. As far as I know, it can be done by using XML Source -> OLE DB Destination.

    However client wants us to use a Script Task by using .Net code in order to achieve this issue.

    Can someone please help?

  • Maybe this question is more appropriate on a .NET forum? There will be people who are more proficient in coding .NET and having more experience dealing with XML using .NET.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Thanks for the reply, thought most of SSIS guys can do some .Net coding.

    No problem, I'll post the same in .Net forum and see if I can get anything...

  • True, even I can do some .NET coding, but I rather stay far away from XML 😀

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • gotcha 🙂

    I'll post it on .Net forum, thanks Koen 🙂

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply