Hi,

I know how to get the name of my DTS using the following:

sMyDts = DTSGlobalVariables.Parent.Name

BUT how do I get the name of the ActiveX Script that I'm currently editing?

I need this so I can report accurately to an Error Log table.

Many Thanks

JD

You cannot, http://tinyurl.com/e34fe

Why not use the built in logging to a table?

For an enhancement to this, if you wish to log your own data along side
this, use the "Show lineage variables..." package option. to expose global
variables of the lineage IDs. You can use these to reference your log data
to the package generated log data.



--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"Jon Derbyshire" <JonDerbyshire (AT) discussions (DOT) microsoft.com> wrote