Post reply

DTS error handling for exec sql tasks

  • September 9, 2005 at 12:26 pm

    #102784

    Hello,

    I am using an Exec SQL task in DTS that executes a procedure.  How can I force the Exec SQL task to complete successfully even if the stored procedure returns an error?  Is there another way to run a stored procedure inside of a DTS package that will allow me to ignore errors?  The procedure is just running and not writing anywhere, so I don't believe setting "max errors" in a transformation would work.

    Anyone have any ideas?  Any help would be greatly appreciated.

  • September 12, 2005 at 8:47 am

    #589101

    There is a setting called ForceExecutionResult that you can set so that the task always completes successfully.

     

    Aunt Kathi Data Platform MVP
    Author of Expert T-SQL Window Functions
    Simple-Talk Editor

  • September 12, 2005 at 9:23 am

    #589106

    Thanks Kathi.  Is ForceExecutionResult  a SSIS thing, or is it available in SQL 2000 DTS?  Everything I am finding on this property is based on 2005 SSIS?

    Thanks again for your response.

  • September 12, 2005 at 9:25 am

    #589108

    This is an SSIS thing. I kind of assumed that you were working in SSIS since this particular forum is for SQL 2005.

    Aunt Kathi Data Platform MVP
    Author of Expert T-SQL Window Functions
    Simple-Talk Editor

  • September 12, 2005 at 9:27 am

    #589110

    Yes, my fault.  I have probably posted this in the wrong forum.

     

  • September 12, 2005 at 9:30 am

    #589111

    No problem. You might try to post in the data warehousing/DTS forum.

    Aunt Kathi Data Platform MVP
    Author of Expert T-SQL Window Functions
    Simple-Talk Editor

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

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