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
Please add a comment to this
if there are other Variables Window features you would like to see implemented.