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

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