DTS Step Message Access 1

[EdwinGene]

Is there a way to access error messages generated by step failures in DTS? For example, I can make the FTP step fail by giving the wrong password and an error message will pop up saying Unable To Connect. Is there any way to access this error message, say in an ActiveX Script task so it can be inserted into a log file? I'm only interested in exception messages, success or connect or other mudane messages are not relevent.

Thanks in advance.

 

[gradley]

Review the KB article below on error handling in DTS.

http://support.microsoft.com/default.aspx?scid=kb;en-us;240221&Product=sql2k

 

[EdwinGene]

Thanks, but I'm really looking for a non-VB way to access detailed error messages in the DTS package, itself? Like with an ActiveX Script Task. Is it possible to access detailed error messages that way?

 

[gradley]

Unfortunately not. VBScript or JScript do not allow you to retrieve the GetExecutionErrorInfo. You need to have a DLL application to get at the GetExecutionErrorInfo.

There are several books written for DTS that discuss this topic. One that I would recommend is "Professional SQL Server 2000 DTS" Wrox ISBN 1-861004-41-9. This book has a full chapter on Error Handling.

 

[EdwinGene]

OK. Thanks.