Set global variable = package name

• dcordle

  SSC-Addicted

  Points: 469

  More actions

  July 1, 2005 at 8:40 am

  #66309

  I'm trying to set a global variable = the package name in an activeX task. It's driving me crazy that I can't figure out something that seems to be so simple. Can anyone help out?

  Thanks

  -D

• DSP-120308

  Hall of Fame

  Points: 3959

  More actions

  July 1, 2005 at 12:39 pm

  #570441

  This should do the trick:

  Function Main()

  DIM oPkg

   SET oPkg = DTSGlobalVariables.Parent

   DTSGlobalVariables("g_PackageName").Value = oPkg.Name

   msgBox("Package Name = " & DTSGlobalVariables("g_PackageName").Value)

   Main = DTSTaskExecResult_Success

  End Function

  Good Luck,

  Darrell