How to assign outer global variables to inner''s

• tutufool

  Valued Member

  Points: 56

  More actions

  November 7, 2006 at 2:26 am

  #173360

  I have a package which will call a couples of "execute package task".

  so I want to init the inner package's globle varibles, how can I do that with an ActiveX script?

  Actually, I want to know how to get the inner package object, so I can:

  oPkg.GlobalVariables("ChildVar").Value = DTSGlobalVariables("ParentVar").Value

  thanks!!!

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  November 7, 2006 at 8:19 am

  #670292

  See this site for an example:

  http://www.sqldts.com/default.aspx?215

  Greg

  Greg

• tutufool

  Valued Member

  Points: 56

  More actions

  November 8, 2006 at 2:12 am

  #670493

  thanks, and I've seen this before.

  actually I don't want to load the inner package in ActiveX code like:

   Set oPkg = CreateObject("DTS.Package")

  ' Assign parameters

  sServer = "(local)"

  sUID = ""

  sPWD = ""

  iSecurity = DTSSQLStgFlag_UseTrustedConnection

  sPkgPWD = ""

  sPkgName = "MyChildPackage"

  ' Load Child Package

  oPkg.LoadFromSQLServer sServer, sUID, sPWD, iSecurity , sPkgPWD, "", "", sPkgName

  the inner packge is already dragged in my package designer.

  all I want to do is something like:

  innerPackage = findInnerPackageByName('taskName')

  any idea?