BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
Posted by Andy Brown on 16 April 2013
You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
Changing the Scope of a Variable in SSIS 2012
Another small blog on something which just caught me out. Virtually everything on the Internet says that you can create a variable scoped to a particular task as follows:
|
|
| Select the task, then ... | ... add the variable. |
The only problem is: it's changed in Integration Services 2012!
This blog assumes that you know what variables are about - it's just to solve a specific problem.
The SSIS 20120 way to change variable scope
You can add a new variable in SSIS 2012 using the Variables window:
Adding a variable - you'll notice I've already created one!
You can then choose to move the variable (an odd term):
Click on this icon to change the scope of the selected variable.
Select the task which should contain the variable:
Here we'll restrict the variable to the Script Task shown selected.
Yeah - the scope has changed!
The scope is now restricted to a specific task.
Don't forget you may need to select the task to see the variables it contains, since by default you only see those with package scope.