-
Question on DTS Package
I have a package which has 4 tasks.
on success of Task 1
then
Task 2
Task 3
Task 4
When i execute the above package through enterprise manager it executes correctly.But when i execute through ASP the order of execution is as follows.
Task 2
task 1
task 3
task 4
Is there anyone who can help me why the execution order is different when i run the package through ASP.
any help would be appreciated.
-
I presume that you have not explicitly defined workflow dependencies between the various tasks. This is the only way to guarantee that they will always execute in the same order (DTS can run taks in parallel and it is often useful to do so, however if two tasks use the same connection, one will run first and the other will wait until it has finished - which one runs first could depend on many random factors).
Right click on the task, select "Workflow" from the pop up menù.
-
The tasks in DTS can be prioritized using ‘RelativePriority’ Property on the parallel run.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|