Creating variables at package runtime

• jane-290555

  SSC Enthusiast

  Points: 119

  More actions

  August 22, 2008 at 8:03 am

  #123186

  I am migrating a dts package to ssis package. In my dts package, there is a ActiveX script to retrieve metadata from database and create global variables to hold these data.

  But it seems in ssis Script task, we can only modify an existing package variable and unable to create new variables at runtime. How do we handle this task in SSIS package? How do we create variables at package runtime? Thanks Jane

• elegantkvc

  SSCommitted

  Points: 1910

  More actions

  March 26, 2009 at 12:12 am

  #966435

  hi,

  you can use the script task editor with the following code

  Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)

  Dim objVar1 As New Variable

  objVar1.Value = "Test"

  objVar1.Namespace = "TempVar"

  End Sub

  Thanks

  vijay