Change Variable Scope with BIxPress

September 13, 2011

One of the biggest annoyances I have when building packages is creating variables in the wrong scope of the package, for instance needing the variable at the package level but mistakenly creating it in the data flow task.  Its not a huge deal to recreate it, but it can be time consuming if you created several variables in the wrong scope.  BIxPress makes it possible to actually change the scope of a variable with a few quick clicks.


The highlighted variable is in the wrong scope, it should be in the package scope (LoopLoadArchive).  To change the scope using BIxPress simply click on the button to start the wizard.


Here you must choose the variable you want to move, if you want to copy or move the variable, and finally what scope you want it moved to.


Click on the green arrow pointing to the right and the variable will be moved.


This has been a huge time saver for me on the times where I have had my head down for hours creating SSIS packages only to realized that I now have a dozen variables set to the wrong scope.  This is just one of many of the hidden advantages of developing SSIS packages with BIxPress.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: