Course description
Prerequisites
Learning Paths
This course will help you prepare for the following certifications and exams:
MCSE: Business Intelligence
MCSA: SQL Server 2012/2014
MCSE: Data Platform
70-467: Designing Business Intelligence Solutions with Microsoft SQL Server
70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012/2014
This course is part of the following LearnNowOnline SuccessPaths™:
SQL Server Integration Services
Meet the expert
Don Kiely is a featured instructor on many of our SQL Server and Visual Studio courses. He is a nationally recognized author, instructor, and consultant specializing in Microsoft technologies. Don has many years of teaching experience, is the author or co-author of several programming books, and has spoken at many industry conferences and user groups. In addition, Don is a consultant for a variety of companies that develop distributed applications for public and private organizations.
Course outline
Handling Errors
Execution With Checkpoints (29:40)
- Introduction (01:11)
- When Things Go Wrong (01:09)
- Restarting Package Execution (02:10)
- Implementing Checkpoints (03:22)
- How it Works (01:14)
- Demo: Using Checkpoints (05:06)
- Demo: Creating a Problem (04:47)
- Demo: Execution Scenario (04:40)
- Demo: The Checkpoint File (02:00)
- Demo: Restart Package Execution (03:21)
- Summary (00:36)
Error Handling and Debugging (16:07)
- Introduction (01:13)
- Precedence Constraints (02:17)
- Demo: Introducing Random Errors (03:38)
- Demo: Adding a Failure Path (02:46)
- Demo: Two Failure Paths (02:55)
- Demo: The Constraint Editor (02:50)
- Summary (00:26)
Error Outputs In Data Flows (20:23)
- Introduction (01:42)
- Error Actions (01:24)
- Demo: Data Conversion Pkg (04:37)
- Demo: Data Conversion Errors (02:37)
- Demo: Configure Error Output (04:31)
- Demo: Redirect Bad Data (04:48)
- Summary (00:40)
Handling Events
Breakpoints (08:43)
- Introduction (00:43)
- Demo: For Loop Container (04:07)
- Demo: Setting Breakpoints (03:20)
- Summary (00:32)
Logging Events (10:31)
- Introduction (00:59)
- Demo: The Data Base & Pkg (04:31)
- Demo: Log Events (04:32)
- Summary (00:27)
Configuring Package Logging (09:56)
- Introduction (01:12)
- Configuring Package Logging (01:57)
- Logging to a Text File (00:26)
- Demo: Configure Logging (04:38)
- Demo: Execute Pkg (00:41)
- Summary (01:00)
Configure for Windows Event Log (04:31)
- Introduction (00:30)
- Demo: Windows Event Log (03:06)
- Custom Logging (00:33)
- Summary (00:22)
Event Handling (25:13)
- Introduction (01:05)
- Event Handling (02:09)
- Handling Errors (00:46)
- Demo: Event Handling Project (04:40)
- Demo: For Loop Container (06:11)
- Demo: Execute the Package (02:12)
- Demo: Create an Event Handler (03:13)
- Demo: Execute & Note Results (04:26)
- Summary (00:27)