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 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Prevent DTS task giving package status of failed?

Author  Topic 

drewsalem
Constraint Violating Yak Guru

304 Posts

Posted - 2006-03-24 : 11:08:12
I have an ActiveX task that, via workflow arrows, does so and so on success, and emails me (via a SQL Task) on failure.

ActiveX Code:
	If oFile.Size > 100 Then
Main = DTSTaskExecResult_Success
Else
Main = DTSTaskExecResult_Failure
End If


If the task fails, the whole package is returned as failed.
Is there a way to have the DTS package not report as failed if a particular task fails?


   

- Advertisement -