using package variable in script task

• sql_learner29

  SSCrazy Eights

  Points: 9107

  More actions

  October 29, 2008 at 2:21 pm

  #131808

  hi,

  I have a small doubt...

  I am having a package varianle varpackage int

  now in my script task i want to initialize the script variable with the value in the package variable like in script tx i have a variable as:

  Dim Counter As Integer

  i want to do counter = varpackage

  Please provide me syantax for this?

  I don't have syntax...How to do this

  thanks in advance..

  [font="Comic Sans MS"]
  ---------------------------------------------------

  Thanks [/font]

• Paul_J

  Hall of Fame

  Points: 3698

  More actions

  October 29, 2008 at 5:53 pm

  #891549

  I hope I understand what you are asking.

  Try this:

  Dim counter As Integer = CInt(Dts.Variables("varpackage").Value)

• sql_learner29

  SSCrazy Eights

  Points: 9107

  More actions

  October 30, 2008 at 8:18 am

  #891828

  Thank si got it...:)

  [font="Comic Sans MS"]
  ---------------------------------------------------

  Thanks [/font]