How do I get error code and messages from DTS or Stored Procedure and write to a log file
Posted on 2004-09-24
All help appreciated. Simple sample code is best.
How do I generate more detailed error code and messages from DTS or Stored Procedure, and pass it to the calling job or write to a log file?
Currently MS SQL 7, moving to MS SQL 2k over the next 2 months
I manually start the job that call the DTS and Stored Procedures.
NOTE: Send email messages is already coded and working. I also want to include the error message, description and line's read or line# in the email. (SENDING THE EMAIL IS NOT part of this request.)
Mostly interested in retrieving the DTS error with line# and possibly part of the line's text back to the job so I can send an email with it. This will help me locate and correct the corrupt text quicker.
I have 2 large fixed format text files, 2gig+ that I dts into a 2 seperate tables. Frequently some of the data is corrupt.
I use KWEdit to open these large text files and regex to try to find the corrupt data. (This is very time consuming and sort of like finding a needle in a haystack!) The whole thing is compounded and additionally time consuming b/c I log in through pc-anywhere. (Cable modem, but still slow!)