SSIS – Changing Variable Scope

If you read my last blog post about SnagIt, you already know that when I was creating the package for my "putting dates in file names" blog post, I inadvertently created the variables at the data flow scope, when I needed to create them at the package scope instead. And if you’ve spent much time working with SSIS, you know that this means I had to delete all of the variables and re-create them, setting all of their properties and expressions all over again.

What a pain. The SSIS tools in Visual Studio will let you change just about any property of a variable, but not the variable scope. There should be some tool to do this, right?

Right!

Well, this is a new feature that is being added to the BIDS Helper Visual Studio Add-In project on CodePlex. Check out the details here: http://www.codeplex.com/bidshelper/Wiki/View.aspx?title=Variables%20Window%20Extensions&version=2

As with quite a few interesting recent additions to BIDS Helper, this feature is not yet part of a major release, so you’ll need to download the source code and build it yourself, but this is relatively simple. Hopefully the project team will have version 1.3 locked down and ready for public release soon, but in the meantime you can get it if you want it. I just wish I’d had it when I was building that sample package…

Advertisements

About ssimagine

My name is Matthew Roche, and I am a Senior Program Manager with the SQL Server product group at Microsoft. I work on Master Data Services and Data Quality Services, and have previously worked on SQL Server Integration Services. Although I work for Microsoft and will be posting on technical topics, I want to stress that this is a personal blog, and any opinions posted here are mine and mine alone. I built my career around SQL Server and Microsoft technologies for well over a decade before I joined Microsoft as an employee, and I plan on using this blog to share my personal experience and opinions. They may well be shaped by my experience on the SQL Server team, but they’re still mine, and not that of Microsoft, disclaimer, disclaimer, etc., etc..
This entry was posted in BI, SSIS, tools. Bookmark the permalink.

3 Responses to SSIS – Changing Variable Scope

  1. Urvi says:

    This comment has been removed by the author.

  2. Urvi says:

    This comment has been removed by a blog administrator.

  3. Thanks for the link to BIDS Helper. It's a great, well, help! 🙂

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