How to Disconnect a Particular Task to Keep From Executing 1

[JohnBates]

hi experts,

SQL Server 2000

I want to "preserve" some ActiveX code within the package - but I don't want this ActiveX Script task to execute when the package runs.

I have removed the Workflow arrow, but the task still executes.

How can I "disconnect" this task from the package execution,
yet leave it visible when I go into DTS Design mode?

I guess I could copy the code into a Text Annotation block, if nothing else will work.

Thanks very much.
John

 

[mrdenny]

Create a dummy step with a select 'hello' in it. Set a condition from the dummy step to your active X step to on failure. The activeX step won't ever run that way (unless the SQL Server is down or something).

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[SQLDenis]

right click on the task select worlflow-->workflow properties and in the options tab select disable this step

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[JohnBates]

Thanks for the valuable tip, SQLDenis !

I tested your suggestion - it works perfectly.

John

 

[SQLDenis]

No problem and thanks for the star
I worked with DTS for 2 years before I found out about it, what I used to do is comment out the ActiveX code and leave just this uncommented

Main = DTSTaskExecResult_Success

that works too BTW

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/