Saturday, February 09, 2013 5:58 AM
I have a parent ssis package that invokes several child packages. One child package executes several times for one execution of parent package. If I execute child package in process ( Execute Out of process = false) it will give error "File is used by another process". I can avoid this by set Execute Out of process to true. But after that it takes so much time to execute child packages. What's the best thing to do in this case?
- Changed Type SSISJoostMicrosoft Community Contributor, Moderator Saturday, February 09, 2013 8:57 AM more appropriate type
Saturday, February 09, 2013 9:35 AM
Are you using excel source...? If yes then windows takes several seconds to close it in that case use delay after execution to get it closed.
If you are using other file please let us know ?
Please mark it as helpful if it helps.
Saturday, February 09, 2013 11:09 AMYes I'm using excel files and other flat files
Thursday, February 14, 2013 8:19 AMModerator
By default, the ExecuteOutOfProcess property of the Execute Package task is set to False, and the child package runs in the same process as the parent package. If you set this property to True, the child package runs in a separate process. In your case, the package will fail if you set ExecuteOutOfProcess property to false, so that you need to set ExecuteOutOfProcess to true to run the child package in a new process. Please refer to: http://consultingblogs.emc.com/jamiethomson/archive/2005/05/16/1414.aspx
TechNet Community Support
- Marked As Answer by Eileen ZhaoMicrosoft Contingent Staff, Moderator Monday, February 25, 2013 3:05 AM