O'Reilly logo

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook by Pedro Perfeito, Reza Rad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 10. Debugging, Troubleshooting, and Migrating Packages to 2012

by Reza Rad and Pedro Perfeito

In this chapter, we will cover:

  • Troubleshooting with Progress and Execution Results Tab
  • Breakpoints, Debugging the Control Flow
  • Handling errors in Data Flow
  • Migrating packages to 2012
  • Data Tap

Introduction

SSIS is a Rapid Application Development tool that helps developers to create data transfer packages with designers and needs less coding, so that the development speed will be much faster. On the other hand, a development tool needs debugging and error-handling features. Fortunately SSIS has a debugging feature in Control Flow scope, also error handling fortified SSIS packages.

In this chapter, we will take a deep look at debugging in Control Flow and ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required