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.
| Author |
Topic |
|
scottpt
Posting Yak Master
186 Posts |
 Posted - 2002-11-08 : 13:39:38
|
| Sql 2000 sp2 with securtity hot fixes. Win 2000 sp3I am moving 2 lrg and 10 small tables. When I originally created the package I had all the transfomations on the same set of connections. In order to speed up the process I created 2 new sets of connections, making 3 connections on each DB, and put the larger tables on their own connections. This creates three "pipes".The issue I am having is that it does not start all three imports at the same time. I beleieve this is because I created the Data Transformation tasks for the smaller tables first, so they execute first. I would like the import of the two larger tables to run at the same time. Is there any whay to change the order in which the Data Transformation tasks execute? |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-11-08 : 14:16:08
|
| Did you check the "Limit the maximum number of tasks executed in parallel to:" setting on the "General" tab of the Package Properties dialog? Maybe you need to kick that up.Jay White{0} |
 |
|
|
|
|
|
Execution order of Data trans.