Re: Writing to task log file

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Darren Green (darren.green_at_reply-to-newsgroup-sqldts.com)
Date: 06/17/04 

Date: Thu, 17 Jun 2004 14:04:03 +0100

You cannot use the log file from within a transformation.

> > 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@discussions.microsoft.com> wrote in message
news:A93D567E-F73E-4358-B270-A117FEC52B06@microsoft.com...
> 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:
>
> > 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@discussions.microsoft.com> wrote in message
> > news:B895D597-3ED6-4CB8-AA04-3A198D310655@microsoft.com...
> > > 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
> > >
> >
> >
> >

Relevant Pages

  • Re: Writing to task log file
    ... 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. ... It is not available in transformation or workflow scripts. ... >> How can I wirte to task log file the object DTSPackageLog is not woking it ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS Transformation Error
    ... script that the transformation should also copy the Source Table structure ... ' Visual Basic Transformation Script ... ' Copy each source column to the destination column ... programming though I'm reasonably familiar with the DTS UI. ...
    (microsoft.public.sqlserver.dts)
  • Re: SSIS & Script Transformation (debug vs normal)
    ... Can you give more details about what the "transformation script" is ... The package is pretty simple. ... but not when ran by sql agent. ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS - aus Space wird Null
    ... Ich habe das Package mit dem "DTS Import/Export Wizard" ... Script generiert wird. ... Welche genau machen könnte, dass da die Transformation Leere Felder in NULL Felder umwandelt, weiss ich nicht. ...
    (microsoft.public.de.sqlserver)
  • Re: Package executes on one machine but not another
    ... I've tracked the error message down to the following. ... As part of the transformation that's failing I assign the Global ... Dictionary object to a local variable i.e. one just dim'd in the ... transformation script. ...
    (microsoft.public.sqlserver.dts)