DTS Error logging | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

DTS Error logging

I am want to store the exact error message when a DTS package falis to a SQL serve table and then send out an e-mail alert with the error message and the DTS name to developers to debug the problem. could you please let me know the easiest way to accomplish this task thank you
How are you running the DTS. Is it scheduled ? One can configure the Agent job to send out email alters when it fails. But If you want to capture the precise error, then as far as I know, you may have to write some Active X scripts in the DTS package and use the Package Object and eventually use DTS events and Errors to capture. Hope this helps.
You can enable the DTS package logging and use that log file to sent out to required people. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.