Strict Standards: Non-static method Settings::setHostName() should not be called statically in C:\website\www.networksteve.com\enterprise\_lib\AutoConfig.php on line 20

Strict Standards: Non-static method Settings::addHostAlias() should not be called statically in C:\website\www.networksteve.com\enterprise\_lib\AutoConfig.php on line 22

Strict Standards: Non-static method Settings::setSiteRoot() should not be called statically in C:\website\www.networksteve.com\enterprise\_lib\AutoConfig.php on line 28

Strict Standards: Non-static method Settings::setDsn() should not be called statically in C:\website\www.networksteve.com\enterprise\_site\Config.php on line 16

Strict Standards: Non-static method Settings::setTitle() should not be called statically in C:\website\www.networksteve.com\enterprise\_site\Config.php on line 19

Strict Standards: Non-static method Settings::setDescription() should not be called statically in C:\website\www.networksteve.com\enterprise\_site\Config.php on line 20

Strict Standards: Non-static method Settings::setSiteRoot() should not be called statically in C:\website\www.networksteve.com\enterprise\_site\Config.php on line 24

Strict Standards: Non-static method Settings::setShowDeleted() should not be called statically in C:\website\www.networksteve.com\enterprise\_site\Config.php on line 31

Strict Standards: Non-static method Settings::setRecentTopicsDuration() should not be called statically in C:\website\www.networksteve.com\enterprise\_site\Config.php on line 36

Strict Standards: Non-static method Settings::test() should not be called statically in C:\website\www.networksteve.com\enterprise\_lib\Init.php on line 28

Strict Standards: Non-static method Skin::test() should not be called statically in C:\website\www.networksteve.com\enterprise\_lib\Init.php on line 29

Strict Standards: Non-static method Settings::getSkin() should not be called statically in C:\website\www.networksteve.com\enterprise\_lib\Skin.php on line 102

Strict Standards: Non-static method Settings::getSiteRoot() should not be called statically in C:\website\www.networksteve.com\enterprise\_lib\Init.php on line 32

Strict Standards: Non-static method Settings::getDsn() should not be called statically in C:\website\www.networksteve.com\enterprise\_lib\Init.php on line 35

Strict Standards: Non-static method Form::field() should not be called statically in C:\website\www.networksteve.com\enterprise\_lib\Init.php on line 39

Strict Standards: Non-static method Form::fieldExists() should not be called statically, assuming $this from incompatible context in C:\website\www.networksteve.com\enterprise\_lib\Entity\User.php on line 92

Strict Standards: Non-static method Form::fieldExists() should not be called statically in C:\website\www.networksteve.com\enterprise\topic.php on line 15

Strict Standards: Non-static method Form::field() should not be called statically in C:\website\www.networksteve.com\enterprise\topic.php on line 17

Strict Standards: Non-static method Settings::getShowDeleted() should not be called statically, assuming $this from incompatible context in C:\website\www.networksteve.com\enterprise\_lib\Entity\Topic.php on line 139

Strict Standards: Non-static method Entity_Post::queryPosts() should not be called statically in C:\website\www.networksteve.com\enterprise\topic.php on line 21

Strict Standards: Non-static method Settings::getShowDeleted() should not be called statically in C:\website\www.networksteve.com\enterprise\_lib\Entity\Post.php on line 111

Strict Standards: Non-static method Skin::showHeader() should not be called statically in C:\website\www.networksteve.com\enterprise\topic.php on line 23

Strict Standards: Non-static method Skin::includeFile() should not be called statically in C:\website\www.networksteve.com\enterprise\_lib\Skin.php on line 46

Strict Standards: Non-static method Settings::getSkin() should not be called statically in C:\website\www.networksteve.com\enterprise\_lib\Skin.php on line 91
Can we run more that one SSIS Package as a job at a time? (Network Steve Forum)
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.
Free Windows Admin Tool Kit Click here and download it now
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
Free Windows Admin Tool Kit Click here and download it now
April 27th, 2011 2:08pm


Strict Standards: Non-static method Settings::getRecentTopicsLimit() should not be called statically, assuming $this from incompatible context in C:\website\www.networksteve.com\enterprise\_lib\Entity\Topic.php on line 121

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics

Strict Standards: Non-static method Skin::showFooter() should not be called statically in C:\website\www.networksteve.com\enterprise\topic.php on line 119

Strict Standards: Non-static method Skin::includeFile() should not be called statically in C:\website\www.networksteve.com\enterprise\_lib\Skin.php on line 56

Strict Standards: Non-static method Settings::getSkin() should not be called statically in C:\website\www.networksteve.com\enterprise\_lib\Skin.php on line 91