During some recent SSIS package development I had cause to access a variable I had defined from scripts in both the Control and Data flows.
So that I remember (and for anyone else that cares) here is the subtle difference in syntax.
(I'm using SSIS 2008)
For the Script Task (within the Control flow) >
1) Add your defined variable to the ReadWriteVariables property of the task.
2) Within the script, refer to the variable like this :
Dts.Variables("User::MyVariable").Value = “New Value”
Within a Script Component (inside a Data flow) >
1) Add the variable to the ReadWriteVariables property of the component.
2) Within the script, refer to the variable like this :
Me.ReadWriteVariables("User::MyVariable").Value = “New Value”
No comments:
Post a Comment