MS SQL Server DTS - DTS Disable step

Author

DTS Disable step

Kalyan

2006-01-20, 8:24 pm

I have 2 steps in my DTS, On Successfull completion of first step, second
steps got error some data issue, after data is fixed I disabled step 1
through Disconnected Edit changed Disabled Steps value to -1

After above changes, when I execute DTS package, it says successfully
completed but step 2 and step 1 is not run.

Any Idea, why this behave like this

thanks
kalyan

Allan Mitchell

2006-01-21, 7:23 am

Hello Kalyan,

If using workflow step 2 follows step 1 and step 1 is disabled then step
2 will not execute. This is different behaviour to that exhibited in SQL
Server 2005.

http://www.sqlis.com/default.aspx?85

You will either need to remove step 1 or you can right click on step 2 and
select fromt he context menu "Execute Step"

Allan

> I have 2 steps in my DTS, On Successfull completion of first step,
> second steps got error some data issue, after data is fixed I disabled
> step 1 through Disconnected Edit changed Disabled Steps value to -1
>
> After above changes, when I execute DTS package, it says successfully
> completed but step 2 and step 1 is not run.
>
> Any Idea, why this behave like this
>
> thanks
> kalyan

Sponsored Links