Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  Capture errors in ActiveX

Author  Topic  TomK Starting Member 12 Posts Posted - 2005-07-27 : 05:15:06 Hi, I want to trap every error that occurs in a DTS into 1 ActiveX box and have the output written into an error log file. Darren Green speaks of a way to do this here: http://dbforums.com/t800639.html but it's not completely clear to me how to implement this. Next to that several other sources claim that it is not possible to trap the step and detailed errormessages into an ActiveX box due to the variant data type. So, is it possible? How do I set it up? Rgrds, Tom