Post reply

Execute SQL Task seting follow failure path.

  • August 24, 2005 at 7:36 am

    #66686

    In an Execute SQL Task how does one set the the condition so that the failure path is taken.  I am doing some error recovery.  So if the file I am processing has already been processed then I want to go down the failure path.

     

    Steve

  • August 25, 2005 at 12:51 am

    #584872

    Raise an error in the SQL Query Task like below..

    RAISERROR ('Error Occured',16, 1)

    and it'll follow the failure path.

  • August 25, 2005 at 6:01 am

    #584920

    Thanks that'll do it!

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

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