Post reply

Datapump Fails in Sub-DTS Process

  • June 12, 2007 at 11:51 am

    #177050

    DTS1 calls DTS2.  In DTS2 there is a datapump task that is erroring.  The cause is the text file either has a '%' in a field and is also used as the delimiter or the text file aborted during it's creation.

    In either case, the pump task will error (it doesn't fail), but the subsequent sqltask completes successfully since it's just an update statement and thereby the whole DTS reports Success.

    How would you catch the datapumptask as a failure so that DTS2 fails and DTS1 also fails and stops processing the remianing tasks?

    My current thought is to change the subsequent SQLTask to an ActiveX Task and check the record count of the destination table.  If 0 fail the DTS, Else continue.

    Open to suggestions.

    ps.  Part of the change will be to use the '|' (pipe) as the delimeter instead of the '%'.

    Regards,
    Matt

  • June 13, 2007 at 4:42 am

    #712550

    Matt,

    In the Package Properties of DTS2, go to the Logging Tab and in the Error Handling section click on Fail Package on First Error. Save that change.

    You can then have an on failure precedence from your ExecutePackage task to another task, say some notification of failure. Or you could just have the package fail....

    I would definitely agree with changing your delimeter too!


    Ade

    A Freudian Slip is when you say one thing and mean your mother.
    For detail-enriched answers, ask detail-enriched questions...[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply