How can I wirte to task log file the object DTSPackageLog is not woking it just complains Object Required. Can someone please tell me how can I get reference to taht object I have searched the complete msdn and there is no documentation on this.

thanks

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.

Unfortunately the DTSPackageLog object is only available inside the ActiveX
Script Task. It is not available in transformation or workflow scripts.
One option for logging inside a transformation script is to use a lookup to
write to a SQL Server table.

Darren


"DTS Dummy" <DTSDummy (AT) discussions (DOT) microsoft.com> wrote

reference to taht object I have searched the complete msdn and there is no
documentation on this.

--
T


"DTS Dummy" wrote:

How can I access the log file from the transformation. I am discarding a record and I need to write the reson in the log file. If I can actually get the script sample how can I access while in the transfomation using VBS that would help me greatly.

"Darren Green" wrote:

You cannot use the log file from within a transformation.

Darren

"DTS Dummy" <DTSDummy (AT) discussions (DOT) microsoft.com> wrote

the script sample how can I access while in the transfomation using VBS that
would help me greatly.