DTS Tasks Order
-
Hello,
I have a DTS package, and I kick it off in an ASP.NET application. I have no problems with doing that; however, the DTS package is starting off with the wrong task first! It's ignoring the workflow order that I've set up in the package. How do you force the order to be correct?
Really weird,
Brian
-
Are you sure you're running the correct version of the package?
Do you have any tasks in the package that are not in the workflow?
Are there any scripts within the package that alter the precedence contrainst or disable tasks?
--------------------
Colt 45 - the original point and click interface
-
My tasks (in the order I want) are below:
1 Dynamic Properties Task
1 Execute SQL Task
4 Data Pump Tasks
2 Execute SQL Tasks
The execute SQL tasks update the data in the SQL Server database, and one deletes data from Access. What it's doing is executing all of the "Execute SQL" tasks first, then it's executing the "Dynamic Properties" task, and then it executes the "Data Pump" tasks.
Through code, I do:
Change Global variables
Set to execute in main thread
I don't:
add or remove tasks
Brian
-
This is where having the ability to post an image would be most helpful.
First, check the properties of each of the workflows and make sure they reference the correct tasks. If everything looks ok, then remove all the workflow and add it again.
--------------------
Colt 45 - the original point and click interface -
Hey,
I did both of those, and still nothing. I followed the suggestion that I found on another site, and save the DTS package as a VB file. I looked at the file, and it creates the steps and precedences in the right order. But when it goes to create the tasks through code, it doesn't order them correctly. Very, very strange. I have another one similar to that one, which I will try using that. I think I may delete and start over, but all in all, this doesn't make much sense.
Brian
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply