Course details

Troubleshooting Data Integration

Troubleshooting Data Integration


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level



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

Target Audience
Data warehouse developers and database administrators who create and manage business intelligence solutions as part of their daily tasks, which include implementing data warehouse databases, extracting and transforming data as part of an ETL solution, and data cleansing

Prerequisites
None

Expected Duration (hours)
1.0

Lesson Objectives

Troubleshooting Data Integration

  • 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
  • troubleshoot SSIS packages in SQL Server 2014
  • Course Number:
    md_idwm_a15_it_enus

    Expertise Level
    Intermediate