• Online, Self-Paced

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

Framework Connections

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.

Feedback

If you would like to provide feedback for this course, please e-mail the NICCS SO at NICCS@hq.dhs.gov.