Hello, I'm trying to execute two SSIS packages simultaneously which have SQL Server Transfer Objects tasks in them, and getting "innerPackage.dtsx" contention issues
Execution failed with the following error: "ERROR : errorCode=0 description=Failed to save package file "C:\Documents and Settings\sqlexec\Local Settings\Application Data\Microsoft\SQL Server\Smo\InnerPackage.dtsx" with error 0x80070020 "The process cannot access the file because it is being used by another process.".
In SQL Server 2000, I could change the script path, and that would fix having the two separate copy objects tasks not try to hit the same area, but in SQL Server 2005, I'm not sure how to accomplish this.
Please help!
Thx. Todd