Can we run more that one SSIS Package as a job at a time?
I have come across on the web somewhere that, With MS SQL Server 2005, only one SSIS package can run at one time. However on MS SQL Server 2008, many can run at a time. Is that correct? Further questions are; 1. Can we run more that one SSIS Package, as a job at a time? 2. Can we run the same SSIS Package, as a job more than one at a time? Sivaprasad S http://sivasql.blogspot.com Please click the Mark as Answer button if a post solves your problem!
April 27th, 2011 4:05am
1. Can we run more that one SSIS Package, as a job at a time? - Yes, add as different steps in the sql agent job. 2. Can we run the same SSIS Package, as a job more than one at a time? - Yes, you can run the same package in different jobs at the same time, but the data integrity needs to be checked while the package runs at the same time.Please mark my post as an answer if I helped you to resolve the issue or vote up if I helped you.Thanks. Regards and good Wishes, Deepak.
April 27th, 2011 4:27am
Yes to both as Deepack said. But in case 2, make sure that you are not trying to move the same data through both packages. This scenario works well if you have an isolated source, such as a flat file to be loaded and your package is designed to handle that flat file through the passing of a string value to a Package Variable that is used in the Connection String of the flat file. That ensures that each iteration of the package, even though running simultaneously, is only loading its own data. If, on the other hand, you have multiple flat files to load, and some large lookups in your data flow, then you should see about loading the files via a For Each loop in one package and cache the lookups for performance.Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.
April 27th, 2011 4:42am
To clarify, The information you've received about SSIS 2005 is inaccurate. It can run multiple packages in parallel. Todd C and Deepak have answered your two specific questions. Talk to me now on
April 27th, 2011 2:08pm