Posts Tagged ‘DTS’
SQL Server > SSIS File System Task Error Message
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.
