Getting Package Names & Id's

• mightyjoemad

  Mr or Mrs. 500

  Points: 556

  More actions

  August 5, 2003 at 6:30 am

  #106048

  Is there a function or stored procedure where I can capture the name & id of a DTS package?

• dm

  Ten Centuries

  Points: 1105

  More actions

  August 5, 2003 at 7:21 am

  #468643

  You can use the DTS object model within a ActiveX script task. Use the following code to put the Name and ID's into Global Variable's

  Dim objCurrentPackage

  Set objCurrentPackage = DTSGlobalVariables.Parent

  DTSGlobalVariables("PackageName") = objCurrentPackage.Name

  DTSGlobalVariables("VersionID") = objCurrentPackage.VersionID

  DTSGlobalVariables("PackageID") = objCurrentPackage.PackageID

  Happy coding,

  Diane