Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Trying to execute two SSIS packages simultaneously which have SQL Server Transfer Objects tasks in them, and getting "innerPackage.dtsx" contention issues Expand / Collapse
Author
Message
Posted Tuesday, September 23, 2008 7:53 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 08, 2009 11:46 AM
Points: 1, Visits: 12
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
Post #574351
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse