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.
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.
- SQL Server 2012 – Transact-SQL Enhancements – Learning Resources
- SQL Server 2012 – Data Quality Services (DQS) – Learning Resources
- SQL Server 2012 – High Availability Enhancements – Learning Resources
- Tips ‘N’ Tricks – SSIS – Ensure Consistency across Packages using Template Packages
- Tips ‘N’ Tricks – SSIS – Define you own Keyboard Shortcuts in SSIS Package Designer
- Tips ‘N’ Tricks – SSIS – Update Properties of Multiple Tasks in One-Go
- Tips ‘N’ Tricks – SSIS – Quickest way to add an existing SSIS Package to a Project
Posted on September 5, 2012, in SQL Client Tools, SQL Server, SQL Server 2012, SSIS, SSMS and tagged Business Intelligence, Databases, Feedback, Microsoft Connect, MSBI, SQL Server, SQL Server 2012, SQL Server Integration Services, SSIS. Bookmark the permalink. 1 Comment.