I have a DTS package which has two data transformations tasks-

If 1st data transformation task fails then package executes the 2nd data
transformation task and subsequent sql steps.

Here is the problem I am facing - When I schedule this package as SQL job,
it shows as failed everytime 1st data transformation task fails though its
not failure for the logic I have in DTS).

Any suggestions to solve this problem to not to show as SQL job failure...

Regards

Hi,

The job status is failed because the dts package has failed. if you put an
active X script task with following script


'************************************************* *********************
' Visual Basic ActiveX Script
'************************************************* ***********************

Function Main()
Main = DTSTaskExecResult_Success
End Function

This will change the status return to success of the DTS package. and the
job will run success too even if one of the task in DTS failed.

Hope this helps


"SQL Replication Guy" wrote: