Results 1 to 9 of 9
  1. #1
    Join Date
    Sep 2003
    Location
    New York, NY
    Posts
    136

    Unanswered: DTS error capturing

    Is it possible to capture the error message when a scheduled DTS package fails and to send it in a mail?

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Can't you code the On Success or On Failure workflow steps?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Sep 2003
    Location
    New York, NY
    Posts
    136
    but that will just tell me whether the step failed or executed successfully, what If I want to capture the error message and send it thru email, in case it failed?
    is it possible to store the error message in some global variable and then read the content in the send mail step?

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    If you're talking about a EXECUTE SQL Task (which you can just about do anything with)...you can trap errors as you would normally do...


    If you're talking about transformations...I don't know..sorry, don't use DTS too much (well, not at all)

    What are you trying to do?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Nov 2003
    Posts
    2

    Re: DTS error capturing

    Originally posted by rohitkumar
    Is it possible to capture the error message when a scheduled DTS package fails and to send it in a mail?
    Hi rohitkumar,

    Did you find the solution? I would like to do the same.

    Thanks
    Stephanie

  6. #6
    Join Date
    Dec 2002
    Posts
    1,245

    Re: DTS error capturing

    You should be able to set up logging for the particular task, and also select to log the particular rows that cause a problem. Then (with a bit of work), you should be able to set up an "on failure" task to e-mail you the log file if there is an error.

    Regards,

    hmscott

  7. #7
    Join Date
    Nov 2003
    Posts
    2

    Re: DTS error capturing

    Originally posted by hmscott
    You should be able to set up logging for the particular task, and also select to log the particular rows that cause a problem. Then (with a bit of work), you should be able to set up an "on failure" task to e-mail you the log file if there is an error.

    Regards,

    hmscott
    Hi,

    Are you talking about the logging options of a package?

    Thanks
    Stephanie

  8. #8
    Join Date
    Sep 2003
    Location
    New York, NY
    Posts
    136
    but checking the logging option on different tasks makes the package run very slow.

    -rohit

  9. #9
    Join Date
    Feb 2002
    Posts
    2,232
    The following link has code to a sp that checks for package errors:

    link

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •