Post reply

Trapping the Error of a Task

  • May 17, 2005 at 2:40 am

    #60563

    Is there any way in which I can trap the error of a previously executed task, from a subsequent task (eg. ActiveX script task)? Are there any properties through wich I can get a reference of the previous task?

    Any suggestion? Thanks in advance

    Gogula

  • May 18, 2005 at 1:46 am

    #559495

    Are you looking to capture the error message? Best method I came up with was to turn on package logging and have a stored procedure extract the required text from there. I just pass the stored procedure the package name, step name and the start time of the step. It returns the error code and Error description from the sysdtssteplog table.

    --------------------
    Colt 45 - the original point and click interface

  • May 18, 2005 at 4:00 am

    #559518

    I found this to be the case as well, just go to the options task menu in the dts step and print the data to a log file... I find this the easiest methodl.

    M

     

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

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