Chapter 9. Implementing Dynamic Packages
Exam objectives in this chapter:
Extract and Transform Data
Define connection managers.
Load Data
Implement package logic by using SSIS variables and parameters.
When you are developing Microsoft SQL Server Integration Services (SSIS) packages, it is a good practice to make each task or transformation as dynamic as possible. This enables you to move your packages from one environment to another (for example, from development to a test environment, and then to a production environment) without opening and changing the package. You can also configure your packages to set different properties at run time.
To do this, you can use the new features in SQL Server 2012, such as parameters and project-level connection ...
Get Training Kit (Exam 70-463): Implementing a Data Warehouse with Microsoft SQL Server 2012 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
