Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2003
    Posts
    83

    Unanswered: Error traping in DTS

    I am using a DTS for my purpose and I am calling that DTS execution in a stored procedure(using master..xp_cmdshell dtsrun/F).I like to store the error meassage or error description in the Stored Procedure if it fails due to any reason.How can I do that?

  2. #2
    Join Date
    Dec 2003
    Posts
    31
    call the dtsrun also with /L<log file path >

  3. #3
    Join Date
    Oct 2003
    Posts
    83
    Will you kindly give me a brief of that please?

  4. #4
    Join Date
    Dec 2003
    Posts
    31
    dtsrun gets some arguments the /L <file path > switch "tells" dtsrun where to log it executed steps results
    for more info search books online for "dtsrun Utility" there you can find all info about dtsrun.

Posting Permissions

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