SSIS Variables Window Extensions

This feature is designed to extend the Variables window in the SSIS package designer. Currently the extension:
  • Adds a button that lets you move or copy a variable to another scope in that package.
  • Highlights the variable icons when expressions or package configurations impact them. (See the Expression and Configuration Highlighter feature for more information about colors and highlighting.)
  • Adds a button that lets you edit the expression on a variable using the Konesans expression editor.

VariablesWindowScopeChangeButton.png

Select the variables you wish to move or copy then click the button. You get the following popup that allow you to choose the new scope for those variables:

MoveOrCopyVariables.png

The move or copy is executed. Then the package is revalidated and the Error List window is updated with any validation errors. For instance, if a task or expression was referring to that variable in the old scope, the package will not validate anymore, and you will need to identify the problem and make the appropriate edits in the package designer to fix the problem.

You can also edit the expression on a variable using the SSIS Expression Editor, as also used in the Expression List:

VariablesWindowEditExpressionButton.png

Please add a comment to this issue if there are other Variables Window features you would like to see implemented.

Last edited Sep 13, 2010 at 9:21 PM by DarrenSQLIS, version 11

Comments

DarrenSQLIS Oct 5, 2011 at 8:12 PM 
@VWylenzek The bug with the variable move option has been fixed and will be included in the next release (1.5.1), Issue 30828.

@amitchotiya If you click the "Choose Variable Columns" button on the Variables Window toolbar, you can include the Namespace column. This is standard SSIS functionality.

Gofalc Aug 15, 2011 at 4:22 PM 
Thank you !!

SvenAelterman Jul 30, 2010 at 10:21 PM 
This is a great addition to BIDS Helper!

amitchotiya May 11, 2010 at 2:06 PM 
Awesome ... ! Great job.

Is there anyway to see the scope of variables in the Package.dtsx xml file ?

VWylenzek Apr 28, 2010 at 3:12 PM 
The multiple scope move action fails, the copy action works perfect!

VWylenzek Apr 28, 2010 at 2:41 PM 
Amazing!!

bkube Jan 8, 2009 at 12:31 AM 
*YOU ROCK* This saved me a BUNCH of time!!!! Thanks for your contribution!!!