foreach-loop-container

Using a variable from Foreach Loop Container in a SQL Task [SSIS]

Ok, I have a simple process... Read a table and get the rows that have a "StatusID" of 1. Simple. Select ProductID from PreorderStatus where StatusID = 1 Foreach row returned from that query, perform an action. For simplicity sake, let's just modify the original table to set the "StatusID" to 2. Update PreorderStatus set StatusID =...

SSIS For Each File Loop and File System Task to copy Files

I'm using a files system task inside a for each loop container, just as described here: link text However, when I execute the package I get this error: [File System Task] Error: An error occurred with the following error message: "The process cannot access the file 'C:\Book1.xlsx' because it is being used by another process.". I do no...