SSIS script global variables - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

SSIS script global variables

Author

Topic

pazzy11
Posting Yak Master

145 Posts

Posted - 2008-02-06 : 06:38:10

How do i access global variables in SSIS scripts ?

the [CODE] Dts.variables("VarName").Value [/CODE]

should work but doesn't ?
do i need to reference the variable another way ?

mwjdavidson
Aged Yak Warrior

735 Posts

Posted - 2008-02-06 : 12:46:30

Is it a script task, or a script component (within a Data Flow Task)?
The method differs between the two:

Script Task

Dts.variables("VarName").Value

Script Component

Variables.MyVariableName

Either way, make sure that you've referenced any variables that you're accessing in the ReadOnlyVariables or ReadWriteVariables properties of the transform or component.

Mark

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources