Changing the Variable Scope with BIxPress

Don’t you hate it when you create that variable in your SSIS package under the wrong scope? Well fret no more because as you have already guessed it BIxPress can handle this. This is just 1 more feature where BixPress can save you time when developing your packages. Below I will show you how you can easily change the scope of your variable without having to delete it.

The first thing you need to do is select the first of the 4 different BIxPress variable options from the tool bar.

This will then open BIxPress and as you can see it gives you 2 options to either Move or Copy a variable. Our first example we will Move or change the scope of the variable. Next we will need to pick which scope to move it to. In our case we will move it to the scope of the script task. Then simply click the big button in the middle that says ‘Move.’

Then BIxPress will inform you that your variable has been moved to a new scope. Simply click OK and you’re done.

Now let’s go back and re-create the original variable with the Copy Variable feature using the same steps above.

To learn more about this feature click here. If you want to find out more about some of the other features of BIxPress click here.