September 17, 2012 at 7:51 am
Not a good week for solving problems on my part.... need help again...
I have a one-off DTSX package I'm trying to throw together to bring in several text files. I have one file that I'm using copies of in the root folder to test against and the Foreach loop Container will only seem to grab just the one. The Data flow task in the Foreach loop is successfully loading the text file to my table; however, it won't loop through and grab any other files. I used the below link to set it up and it still no worky... :crying:
http://www.sqlis.com/sqlis/post/Looping-over-files-with-the-Foreach-Loop.aspx
There is one exception to the link that I haven't been able to correct. When I assign the scope of the variable I don't have the option to assign it to "Package" as in the example. I assign it to the highest node I can. The last time I did this it was the same situation and it worked so I'm obviously missing something insignificant.
Any general culprits I can check?
Thanks
Crusty.
September 17, 2012 at 7:57 am
What the SAM-HILL in TARNATION... dumb thing started working... which what one of you yahoos fixed it when I wasn't looking!!!???!!!:w00t:
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply