Activex script - DTSGlobalVariables.Parent - error

Hi,

I migratedDTS From sql server 2000 to 2005 .

But i have problemes with the ativex :

Error: 0xC0048006 at Loop action, ActiveX Script Task: Retrieving the file name for a component failed with error code 0x000F5544.

In DTS ActiveX scripting it was common to get a reference to the package itself using the following line of code:

Dim package = DTSGlobalVariables.Parent

This was used to navigate over the DTS object model , to loop.

Someone can help me to know haw I can do the same thing with the SSIS.

Regards,

chaf wrote:

Hi,

I migrated DTS From sql server 2000 to 2005 .

But i have problemes with the ativex :

Error: 0xC0048006 at Loop action, ActiveX Script Task: Retrieving the file name for a component failed with error code 0x000F5544.

In DTS ActiveX scripting it was common to get a reference to the package itself using the following line of code:

Dim package = DTSGlobalVariables.Parent

This was used to navigate over the DTS object model , to loop.

Someone can help me to know haw I can do the same thing with the SSIS.

Regards,

You should take a look at these links. They will help you:

Get a reference, within a script, to the package using DTSGlobalVariables.Parent
(http://blogs.conchango.com/jamiethomson/archive/2006/07/26/4278.aspx)

Modifing a Package in script
(http://blogs.conchango.com/jamiethomson/archive/2006/06/28/4156.aspx)

-Jamie