I have an Excel Connection using the MS OLE DB provider for Office 12 and a Data Flow task to load the data. The filename is set dynamically with an Expression and some variables. The DFT runs fine, then there are a couple of steps that do NOT reference
the Excel connection, then there is a File System Task set to MOVE the file to a \Loaded folder. I keep getting the error "
The process cannot access the file because it is being used by another process
There are no other processes that would be access this file other than the SSIS package itself. I even put in a Script task the pauses 30 seconds (just in case the Data Flow hasn't had enough time to release the connection). Still get the error. Once the
package finishes with this error and I stop the debugging, I can manually execute the one Move File task and it goes OK.
How do I get the DFT to release the hold on this file?Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.
View Complete Post