Writing to DTS Package Logs thru ActiveX Scripts
February 20th, 2006 // 5:28 pm @ Amar
If you would like to write custom error messages to the DTS log files thru your ActiveX scripts, the DTSPackageLog.WriteStringToLog method can be of help.
Just call it as
DTSPackageLog.WriteStringToLog “Custom Error Message”
and it will appear as a Task Log in the log file.
Category : SQL Server