Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 SSIS Package Simultaneous Processes

Author  Topic 

albertkohl
Aged Yak Warrior

740 Posts

Posted - 2010-06-16 : 01:20:15
Question, is there any way to increase the number of simultaneous processes that an SSIS package can run? i basically have a script task, that spiders out to 20 separate T-SQL Tasks (so i can basically thread 20 processes all at once), but when testing it, i see that SSIS is only running 6 of the 20 tasks at once.

is there any way to jump it up to run all 20?

dattatreysindol
Starting Member

20 Posts

Posted - 2010-06-16 : 02:25:59
Hi There -

Take a look at this video on msdn.
http://msdn.microsoft.com/en-us/library/dd795221(SQL.100).aspx
Hope you will find it useful.


Dattatrey Sindol
http://mytechnobook.blogspot.com/

This information is provided "AS IS" with no warranties, and confers no rights.
Go to Top of Page
   

- Advertisement -