Hello!
I have scanned my DTS book and several sites and have not been able to find this. I am logging the insert or transform errors in SqlServer, but cannot figure out how to access the specific error message (the one that comes up in the text log file) like "..insert of x column failed because of NULL .. ".

The closest was an Error Code from the DTSTransformPhaseInfo object, but I have no idea what error description this correlates to or even if it is the same error. I am sure this can be accessed from *somewhere*, since after all, it is being written to the exception file.

(I had to go through this exercise to begin with because I need to continue processing subsequent rows if I encounter an error as well as save details on the error rows. SqlServer replaces rather than appends information in the .Dest and .Source tables that capture row details (when the package is re-executed). Secondly, it appears that only DTSTransformStat_OK continues further processing BUT this does not write details to the exception file.)

Any help will be much appreciated!
Aarti