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.


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:


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:


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 8:21 PM by DarrenSQLIS, version 11