Variables Toolbar Extension

Parent Previous Next

Variable Toolbar Extension

Toolbar Features

BI xPress Variable toolbar extension has 4 unique features. If you don't see the variables toolbar extension buttons even though BI xPress add-in is loaded, then just click on variable name once and it will appear.

When you launch variable copy/move dialog box it automatically checks items based on selected variables in the BIDS Variables Grid.

Variable Copy / Move

To copy or move variables click on "Move/Copy Variables" icon (Found on the variable toolbar) to Variable Copy/Move dialog box.

Important Note:

Variable Copy / Move has been deprecated within Visual Studio 2015 and above.

 New Value/Expression Editor
If you have ever tried to assign multi-lines text to variable then you know it is not easy to do in BIDS. With this version you can do it with "Single click. 

Click on "Edit Variable" icon (Found on the variable toolbar) to launch value editor. Check "Evaluate As Expression" option to switch to expression mode to show the expression editor.

 Expression Manager

Expression manager button launches a new dialog box where you can view and organize SSIS expressions.

 Variable and Parameter Dependency Scanner
Variable and Parameter Dependency Scanner find places within the current package where variables and parameters are used. Variables and parameters can be used in control flow, Data Flow or anywhere inside event handler. Variable and Parameter Dependency Scanner finds variable usage in the following location.




  Log Providers


  Event Handlers

  Precedence constraints


  Most Data Flow Components

Using this feature you can also detect unused variables. When you click this option you can select "scan only selected variables" or" all variables" as below.

You can rename or delete unused variables and package parameters with a single click. Click on Rename Unused to rename all checked variables or parameters under the "Unused Variables and Parameters" node. Click on Delete Unused to delete all checked variables or package parameters under the "Unused Variables and Parameters" node. Unused project parameters will not be renamed or deleted.