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 faiure for the logic I have in DTS).

Any suggestions to solve this problem to not to show as SQL job failure on
"first error" etc...

Thank you