DTS task logic

8 Jun 2006 11:10 PM

GB

Hello,
My DTS package is a sequence of tasks.
Can I add a logic to the task sequence?
For example: If ... then do these tasks, else do that task?

Thanks,
GB

9 Jun 2006 1:15 AM

Stu

Sure; there a couple of different ways to do this in DTS.

If your programming logic tests can return a success or failure, then
you can use the Workflow feature to do something on Success or do
something else on Failure. If your logic is more complicated than
that, then you can use the Dynamic Properties task to switch on or off
alternate Workflow paths based on some condition, which you will
probably have to store in a global variable.

HTH,
Stu
GB wrote:
Show quote

> Hello,
> My DTS package is a sequence of tasks.
> Can I add a logic to the task sequence?
> For example: If ... then do these tasks, else do that task?
>
> Thanks,
> GB