Trouble with Script Component Variable reference

• TangoVictor

  SSChampion

  Points: 10975

  More actions

  August 3, 2009 at 10:25 am

  #137099

  I am using a script component within a dataflow. In the preExecute sub I am trying to reference a variable using the format :

  dts.variables("VarName").value.tostring

  This same format works fine in a Script Task. The namespaces between the Task and Component are the same. The only difference is in the Script Task there is a reference to sqlserver.ScriptTask. There is no reference available for script component. I don't think this has anything to do with variable references.

  The component is setup as a destination.

  Namespaces:

  Imports System

  Imports System.Data

  Imports System.Math

  Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper

  Imports Microsoft.SqlServer.Dts.Runtime.Wrapper

  Imports System.Xml

  Imports Microsoft.SqlServer.Dts.Runtime

  Error:

  Name "dts" not declared

  I'm looking for the correct method to reference a package variable in a Script Component.

• Paul_J

  Hall of Fame

  Points: 3698

  More actions

  August 3, 2009 at 4:59 pm

  #1033993

  Try this:

  Me.ReadOnlyVariables("varname").Value

  You will also need to add the variable to the ReadOnlyVariables or ReadWriteVariables in the Script Component properties of course.

• TangoVictor

  SSChampion

  Points: 10975

  More actions

  August 3, 2009 at 5:50 pm

  #1034002

  Thanks that did the trick!