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.
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
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.