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