Menu
The general approach should be something like this: SELECT b. value('(./SomeNode/text())[1]','nvarchar(100)') as [Some_Text], b. value('(./SomeOtherNode/@VAL)[1]','int') as [Some_Val] FROM [SOME_TABLE] CROSS APPLY [XML_FILE].
For this purpose, we use an XML Source task from the SSIS package toolbox. Drag this XML Source in the Data Flow. SSIS adds the task in the data flow task created earlier. For the source configuration, double-click on the XML Source, and you get an XML Source editor.
Hi all i'm new to SSIS and i'm wanting to read a bunch of xml files in a specific folder. I would like to read the xml files and output the data in a database table. However i'm a little bit confused as to where to start. Could someone point me in the right direction? I've had a search on the internet but all the tutorials seem to cover looping through txt files and not xml files. I will be using sql server 2005 if that makes any difference.
Many thanks :)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With