DTS Workflow precedence

#1

I am having diffculty defining a workflow for my package.

Normally this would be a simple execution of tasks, however should task 2
fail then another task not within the normal sequence of steps needs to be
executed, once complete this should then return to step 3 as if step 2 had
completed ok.

Can anyone suggest a way to achieve this.

#2

"Filby" <mark (AT) aimnospam (DOT) com> wrote

Quote:

Normally this would be a simple execution of tasks, however should task
2
fail then another task not within the normal sequence of steps needs to
be
executed, once complete this should then return to step 3 as if step 2
had
completed ok.

not easy, but there's a complete example onto: sqldts.com; try this:
http://www.sqldts.com/?218

#3

This is actually easier to implement and maintain, and you can achieve the
same overall with a bit of thought.

Skip the execution of an individual Task
(http://www.sqldts.com/default.aspx?214)

Darren Green
http://www.sqldts.com
http://www.sqlis.com

"Paolo Fiore" <postaBELIN (AT) paolofiore (DOT) it> wrote

Quote:

"Filby" <mark (AT) aimnospam (DOT) com> wrote in message
news:e1417e20ae8c424d9c22f19cefe17d63 (AT) ureader (DOT) com...

Normally this would be a simple execution of tasks, however should task
2
fail then another task not within the normal sequence of steps needs to
be
executed, once complete this should then return to step 3 as if step 2
had
completed ok.

not easy, but there's a complete example onto: sqldts.com; try this:
http://www.sqldts.com/?218

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

DTS Workflow precedence

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

DTS Workflow precedence - 04-18-2005 , 05:57 AM

Re: DTS Workflow precedence - 04-18-2005 , 07:21 AM

Re: DTS Workflow precedence - 04-18-2005 , 10:26 AM