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.
start the course
design dynamic SSIS packages
implement package configurations for files
implement package configurations for SQL tables
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
The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.