How can an ActiveX script reference the package that contains it?

#1

I am trying to write an ActriveX Script task inside an
existing DTS package.

In the code, I can see how to reference the package by its
name using the LoadFromSQLServer method, but I don't like
hard-coding the name of the parent package.

Is there a way to reference the package more generically,
or is there a way to interrogate DTS or SQL Server or to
find out the name by a method?

TIA,
Ross Evans

#2

DTSGlobalVariables.Parent will give you the package.

--
-Euan

Please reply only to the newsgroup so that others can benefit. When posting,
please state the version of SQL Server being used and the error number/exact
error message text received, if any.

This posting is provided "AS IS" with no warranties, and confers no rights.

"Ross Evans" <ross.evans (AT) STOPTHEMADNESStwc (DOT) state.tx.us> wrote

Quote:

I am trying to write an ActriveX Script task inside an
existing DTS package.

In the code, I can see how to reference the package by its
name using the LoadFromSQLServer method, but I don't like
hard-coding the name of the parent package.

Is there a way to reference the package more generically,
or is there a way to interrogate DTS or SQL Server or to
find out the name by a method?

TIA,
Ross Evans

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

How can an ActiveX script reference the package that contains it?

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

How can an ActiveX script reference the package that contains it? - 08-22-2003 , 12:34 PM

Re: How can an ActiveX script reference the package that contains it? - 08-22-2003 , 04:45 PM