October 5, 2012 at 6:32 am
I have created a package to loop through a folder and find all xml files.
My Foreachloop container seems fine I have a variable which knows there are 3 files.
However I think the problem is with my XML Source Editor.
I have 3 options for data access method.
1. File from Location
2 File from variable
3 Data from variable.
I have one variable assigned in the package on the foreEach Loop container.
When I choose 1 it loops the same file 3 times
When I choose 2 (create another variable to point at one file) same result as 1
Not tried 3.
How do I configure XML SOURCE EDITOR in SSIS to loop through all files.
Some instruction on the net for csv,txt and xls files but XML is slightly different and has it's own editor. Somehow I thing I'm missing a variable. But where and how to implement. GRRRRRRRRR!!!!!!!
Any pointers would gratefully be appreciated.
October 5, 2012 at 7:33 am
Check the following link
http://stackoverflow.com/questions/3824461/ssis-xml-task-with-a-for-each-loop
October 5, 2012 at 2:24 pm
Ahh Might just work I have seen that done for the excel connection manager maybe I shouldn't be using XML Source and should use XML Task.
Thanks I'll try it on Monday.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply