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.

  Package

  Tasks

  Connections

  Log Providers

  Configurations

  Event Handlers

  Precedence constraints

  Variables

  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.