Post reply

How do you make a sql task fail in a DTS package?

  • June 2, 2006 at 8:04 am

    #91956

    In a DTS package, I have various SQL tasks which are linked by  workflows, either 'on success' or 'on failure'.

    What is the sql statement for making a sql task fail so that it follows the 'on failure' workflow?

    Thanks

  • June 2, 2006 at 8:57 am

    #641467

    Many options to choose from. Divide by zero should do it:

    SELECT 1 / 0

  • June 10, 2006 at 5:37 am

    #642963

    RAISERROR with a severity of 16

    SQL = Scarcely Qualifies as a Language

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

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