July 26, 2005 at 5:34 am
hi
i need to skip some tasks depends on the conditon.
Consider task 1 , task 2 , task 3 , task 4 , task 5 task 6 .... task 20 All tasks are executed serially.
Step 1 i run the package.
Step 2 consider Task 5 . task 11 are failed due to some data problem.
Step 3 User corrects the problem in source ,
Step 4 i will run package ; During this run , only failed task 5 and task 11 shoud be executed ;not all the tasks.
currently i make all tasks inactive except task 5 and task 11. i mention all tasks between task 1 and task 4 to make inacitve.is there any other solution ?
pls help me out
Thanks in Advance
Jones
July 26, 2005 at 10:53 am
Hi
Why don't you try to use a Control Table where you register when a task runs OK. In the end of each task you register if it ends sussecfuly.
In the end if all tasks run OK you will mark this DTS as OK, if not in the next run DTS will just run the tasks that didn't end.
You should have some ActiveX to make the task ready to run or not.
Hope it helps,
Vitor
July 26, 2005 at 12:09 pm
Jones,
Here is a link that will show you how to skip individual steps/tasks in a DTS package.
http://www.sqldts.com/default.aspx?214
Good Luck,
Darrell
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply