SSIS in SQL Server 2014 allows for dynamic packages and to enable values within the package to be manually set, depending on your requirements at execution time. In this course, you will learn about designing SSIS packages.
Learning Objectives
Packages
- start the course
- design dynamic SSIS packages
- implement package configurations for files
- implement package configurations for SQL tables
- use expressions
- implement package and project parameters
- describe project level connection managers
- set connection manager properties using expressions
- configure packages in SSIS for different environments
- configure the following packages: xmlconfiguration file, SQL Server table, registry entry, parent package variables, and environment variables
- implement project and package level parameters
- use project connection managers
- use expressions to set property values
Practice: Creating SSIS Packages with Logic
- create SSIS packages with logic