If a stored proc within a dts fails...

  • If I have a step inside my DTS package that runs a Stored Proc, and that stored proc fails...does DTS pick up the error or just state the task ran successfully?

    Its only just occurred to me today that it might not report a failure/issue!

  • The task of the DTS shows as failed. If you have set up any file to capture the error details (Steps tab-->Advanced options), you can see more info on the error.

    Renuka__

    [font="Verdana"]Renuka__[/font]

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

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