Post reply

Error Messages

  • January 30, 2008 at 10:06 pm

    #119737

    Hi,

    I'm using DTS and need to catch the error message. how to retrieve the error messages. i have used workflow as "onFailure" in the DTS. so when the error is generated during the process then, error subroutine should catch the error message.

    Is there any method to get the SQL Server messages??????

  • January 31, 2008 at 3:11 pm

    #773970

    Did you try to add log file in your DTS? If so, you can trace errors in detail.

  • January 31, 2008 at 11:20 pm

    #774064

    hi

    could you explain how to incorporate the log file????

  • February 1, 2008 at 12:57 pm

    #774416

    Open your DTS in design mode;

    Choose Properties from Package on the menu at your top left;

    It is under the logging tab.

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

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