Is there a way to stick something in the package's configured log from an
ActiveX Script? I've got a script that uses an external component to help
parse an XML document that's loaded from a text field in the source table.
If the document is invalid, I want to log the record's key value and
continue processing with the next record rather than fail the entire step.

Any help would be appreciated.

Lamont Adams
MCP

What about

DTSPackageLog.WriteStringToLog "Hello World"




"Lamont" <lamontadams1_at_yahoo_dot_com.nospam> wrote

Hmm. Hadn't run across that one yet... sounds like a winner. Thanks
"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

By the way, is there a list somewhere of what intrinsic objects are
available to a script in DTS?

"Lamont" <lamontadams1_at_yahoo_dot_com.nospam> wrote

Hey Allan,
Is DTSPackageLog.WriteStringToLog for logging errors only?
Is there a way you can use DTSPackageLog.WriteStringToLog to log
information.
Simple example
DTSPackageLog.WriteStringToLog "ActiveX Script 1 Begun"
DTSPackageLog.WriteStringToLog "ActiveX Script 1 Checking for file..."
DTSPackageLog.WriteStringToLog "ActiveX Script 1 File 1 found..."

I'm not sure I'd ever actually use this to do something like this, I'm
just curious as to the functionality of the statement.

Simon Worth

Allan Mitchell wrote:

Allan,

Looks like this is only available to ActiveScriptTasks, not to
transformation scripts. I get script errors when I try to use it in the
latter situation.

Any other ideas? :-)

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote