SQL Server 2012 – Ability to Replicate Environments and Copy Variables Across Environments in SSIS Catalog

Most of you who are aware of SSIS Enhancements in SQL Server 2012, might already be knowing that in the Deployment Model, we can now create something called as an Environment (say one for each like Dev, Test etc.) in SSMS and add variables to each of the environment to hold the configurable values for each of the environments. I noticed that, we need to create the variables for each of the environments separately even if all the environments are using the same set of variables, which is a duplication of effort and a tedious job if number of variables is huge.

As part of this observation, I have submitted a feedback to Microsoft on the Microsoft Connect site. Below is a snapshot of the feedback. If you want to see this feature in future updates (May be in Service Packs), please vote for this feedback by clicking on the link below the screenshot.

image

SSIS 2012 – Ability to Replicate Environments and Copy Variables Across Environments in Catalog

I am in the process of writing my next post on the Learning Resources for SSIS Enhancements in SQL Server 2012 as part of the SQL Server 2012 Enhancements Learning Resources series.

Advertisements

About Dattatrey Sindol (Datta)

Datta is a Microsoft BI Enthusiast, passionate developer, and a blogger. View Full Profile

Posted on September 5, 2012, in SQL Client Tools, SQL Server, SQL Server 2012, SSIS, SSMS and tagged , , , , , , , , . Bookmark the permalink. 1 Comment.

What are your thoughts?

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: