have you any wool?

I was playing around with SQL Server Integration Services tonight and I was stuck on an issue and it took me a while to find the resolution. When nesting a File System Task inside and ForEach File Loop, it’s rather difficult to perform tasks on the file iterations using a variable. I Googled some solutions and this one ended up being the closest to be eventual solution.

 I figured I would put it out here on a blog in hopes of that someone else might come across it when racking their brain trying to figure out this issue.

http://www.tek-tips.com/viewthread.cfm?qid=1265108