SSIS - Once a package has been loaded, can it be executed multiple times?

Question

We have a situation where we are importing a number of files with the same format, using the same SSIS package. The package is being loaded and executed from a .net assembly. Currently the package is being reloaded for each file.

I would like to load the package once during the initialisation of the .net process, and then execute it for each file, to save the overhead of re-loading the package for each file. Is this a safe process to follow?

Answer 1

It seems like it would be safe to me. But I would run some controlled tests on the process, perhaps with a very simple SSIS package first, then your more complex one.

I can't say that I have done this exact scenario myself.

Answer 2

In the end, I used a foreach loop in the package to process each file in term. This was very fast! I still have a lot to learn about SSIS!