h1

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.

image

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.

image

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.

image

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

image

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.

Advertisements

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: