Does anyone know if it is possible to add your own custom messages to the
DTS Package status messages from within an ActiveX script task in the DTS
package? I'd like to put out some information at the beginning of the DTS
package status message that you can see when you look at the job step
history in SQL Server Agent. Somewhere within the messages it currently
shows like the following:

Executed as user: PERFORMANCE1\SYSTEM. ...
DTSStep_DTSDynamicPropertiesTask_1 DTSRun OnFinish:
DTSStep_DTSDynamicPropertiesTask_1 DTSRun OnStart:
DTSStep_DTSActiveScriptTask_1 DTSRun OnFinish:
DTSStep_DTSActiveScriptTask_1 ...

I guess I would want them to go between the DTSRun OnStart:
DTSStep_DTSActiveScriptTask_1 and DTSRun OnFinish:
DTSStep_DTSActiveScriptTask_1 status messages

Thanks,
Ray

-------------------------------------------------------
rrankins (AT) gothamconsulting (DOT) com

In message <#fOEPX05DHA.488 (AT) TK2MSFTNGP12 (DOT) phx.gbl>, Ray Rankins
<dbadmin (AT) gothamconsulting (DOT) com> writes
In an ActiveX Script task you can use the DTSPackageLog object-

DTSPackageLog.WriteStringToLog "My String"

DTSPackageLog.WriteTaskRecord 1, "Desc"

See the PackageLog object in Books Online for documentation of this
object.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org