Post reply

Getting SP return values to DTS

  • May 5, 2003 at 12:46 pm

    #175601

    I'm using Execute SQl Task in DTS and want to capture the return values from a SP I'm calling. If value from SP is failure code I would like to fail DTS...

    Who would I do this??

    Thanks

    JpII

  • May 6, 2003 at 1:43 am

    #456248

    Use your workflow precedents to tell the package what to do if the step fails and/or suceeds.

    If you have multiple branches and want to make sure that the DTS package fails on the first error, then view the properties and check the box that says "Fail on first error."

    My blog: SQL Soldier[/url]
    SQL Server Best Practices:     SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]

  • May 6, 2003 at 8:37 am

    #456286

    It's not if the SP fails that I'm looking for.

    It's if the process in SP fails and returns an error code as return value.

    I want to capture the return code and validate it, if 0 good, if -1 Bad faile package.

    JpII

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

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