all groups > sql server dts > june 2004 >
You're in the

sql server dts

group:

Writing to task log file


Writing to task log file DTS Dummy
6/11/2004 1:18:01 PM
sql server dts:
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
RE: Writing to task log file Tony
6/14/2004 2:12:02 PM

--
T


[quoted text, click to view]
Re: Writing to task log file Darren Green
6/14/2004 5:18:51 PM
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


[quoted text, click to view]
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.
[quoted text, click to view]

Re: Writing to task log file DTS Dummy
6/15/2004 12:36:02 PM
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.

[quoted text, click to view]
Re: Writing to task log file Darren Green
6/17/2004 2:04:03 PM
You cannot use the log file from within a transformation.

[quoted text, click to view]

Darren

[quoted text, click to view]
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.
[quoted text, click to view]

AddThis Social Bookmark Button