January 10, 2007 at 3:54 pm
I have built a DTS package that consists of sets of tasks: executeSQL task1 to clear stagng table, datapump task2 to load the stagng table from an outside source and executeSQL task3 to load the data from the stagng table to the live table. Each of these tasks is connected to the following using a success precedence constraint. task1 is on connection 1, task2 copies from connection 2 to connection 1 and task3 operates on connection 3 (which connects to the same SQL server database as connection 1).
Only one set can start at a time, which is what I want (our outside connection limits the number of connections to the server). As soon as the datapump completes I want another set to start, which it currently does do. But what I want to also happen is for the task3 to start running.
What I see when I execute the dts package is that one set is actually running. Three other Task2 steps are shown as started and all of my Task3 steps are shown as Waiting.
Is there anyway in code to start the Task3 task as soon its Task2 finishes?
Russel Loski, MCSE Business Intelligence, Data Platform
January 10, 2007 at 6:13 pm
Right click in dts pacakge white pane/click properties/general tab ... at the bottom of the tab..
Change "Limit the maximum number of tasks executed in parallel" to 1 where as default is 4.
MohammedU
Microsoft SQL Server MVP
January 11, 2007 at 5:43 am
I think that is what I will do, since Task3 does not take too long to run. My goal is to have Task3 run while Task1 on another set begins.
Russel Loski, MCSE Business Intelligence, Data Platform
January 12, 2007 at 9:18 am
I have set the priority for the Task3 steps higher than normal. I will watch to see if that achieves the results I want.
Russel Loski, MCSE Business Intelligence, Data Platform
January 15, 2007 at 6:43 am
Did you try workflow sequence ?
January 15, 2007 at 9:12 am
I have basic workflow (Task2 starts on success for Task1, Task3 starts on success for Task2). I would prefer not to link the sets in a workflow. I'm not sure which of the sets will finish first.
I have tried in the past where I had Task1 then task2 of set1. Task2 leads to Task1 of set 2 and Task2 of set1. This might achieve my goal.
Russel Loski, MCSE Business Intelligence, Data Platform
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply