Post reply

Error Handling In DTS

  • June 24, 2008 at 4:16 am

    #193100

    Hi,

    I am working with DTS packages in SQL 2000 and would like to get the error details on failure of a task so that I can write into a file rather than using default logging method.

    The flow of my package is as follows:

    1) Update a table using Execute Sql task

    2) Transfer data using Transform Data Task

    3) On failure of step2, I want the error details to be available in ActiveX and thereby write to an external file.

    Please comment on how this can be achieved...

    --Danya

  • June 24, 2008 at 1:20 pm

    #833563

    Look up the GetExecutionErrorInfo method of the DTS Package Step object in Books online.

    An example can be found in the .zip download at http://www.sqlmag.com/Article/ArticleID/6196/sql_server_6196.html.

  • June 24, 2008 at 9:48 pm

    #833691

    Hi,

    Thanks for the reply. But I believe this method GetExecutionErrorInfo cannot be used from ActiveX Script. What I wanted was to get the error details available in ActiveX script. Please refer to the link below :

    http://www.dbforums.com/showthread.php?t=536200

    --Danya

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

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