• Online, Self-Paced
Course Description

SSIS includes tools and features that can be used to troubleshoot data integration. In this course, you'll learn how to debug and troubleshoot packages at the design and production level using techniques such as data viewers.

Learning Objectives

Data Integration Troubleshooting

  • start the course
  • recall considerations for troubleshooting and what to look for
  • troubleshoot performance issues
  • troubleshoot execution of a task or transformation failed
  • troubleshoot logic issues
  • demonstrate awareness of the new SSIS logging infrastructure
  • troubleshoot SSIS package failure from an invalid datatype
  • use break points
  • use data viewers
  • profile data with different tools

Practice: Troubleshooting SSIS Packages

  • troubleshoot SSIS packages in SQL Server 2014

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.