Execute Out Of Process or In Process

Question

HI,

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?

Thanks.

Answer 1

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.

Thanks

Sumit

Answer 2

Yes I'm using excel files and other flat files

Answer 3

Hi Anush87,

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

Thanks,
Eileen

---

Eileen Zhao
TechNet Community Support