Sunday, February 19, 2012

Execute package on a for each loop container

Hi. I am running a package using 'execute package' inside a for each loop file iteration. I have to iterate through some 10,000s of files to ETL source data, a resonably complex package. I want to set going and get some sleep but every 200 files or so I get a memory exhausted error and the task fails. Is there a short easy fix to refresh memory each iteration. If so please let me know. Just ignoring the failure at task level won't refresh the memory, will it?

Thanks for the help.

Canyou try setting the ExecutePackage task to have 'OutOfProcess=True' - I am not sure if that will work but it is worth trying.

No comments:

Post a Comment