Stop DTS Package from running - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Stop DTS Package from running

Author

Topic

ddobbertin
Yak Posting Veteran

51 Posts

Posted - 2008-05-06 : 11:29:32

I'm trying to stop a DTS package from continuing to run after the result of the following ActiveX script:

Function Main()
If day(date) > 2 and day(date) < 10 and weekday(date) = 2 Then
Main = DTSTaskExecResult_Success
Else
Main = DTSTaskExecResult_Failure
End if
End Function

Any help would be appreciated.

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2008-05-06 : 11:32:59

Set "Fail Package on First Error" property of the package true.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-05-06 : 11:33:23

You can delete the workflow task starting from activex and disable the next tasks and try rerunning package if it is for debugging purpose.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources