Home / Microsoft EBooks / Microsoft SQL Server 2012 Integration Services (SSIS)

Microsoft SQL Server 2012 Integration Services (SSIS)

Microsoft SQL Server 2012 Integration Services (SSIS) provides significant improvements in both the
developer and administration experience. New SSIS features have been introduced in order to improve
developer productivity, and simplify the deployment, configuration, management and troubleshooting
of SSIS packages.
SQL Server 2012 Integration Services introducesthe project as a self-contained, deployment unit.
Common values can be shared among packages in the same project through project parameters and
project connection managers. ETL developers caneasily reference child packages that are inside the
project.
Solutions that were created in earlier versions of SSIS (pre-SQL Server 2012) will be supported in SQL
Server 2012. When you upgrade the solutions, you can take advantage of the new SQL Server 2012
features. Although in SQL Server 2012 SSIS offers wizards for upgrading most solution components,
there will be a few settings that you’ll need to change manually.
Here are a few tips that can help to make the upgrade successful.

Leave a Reply

Your email address will not be published. Required fields are marked *