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

Handling errors in Data Flow

Data Flow is the most important and useful part of SSIS packages. Data will transfer there, and if errors occur, there should be an error catching method. The importance of such error catching feature is mostly due to the fact that data flows will transfer millions of data rows in nightly schedule, and maybe re-producing an error which occurred at night can't be possible for a second time.

Fortunately SSIS Data Flow uses a powerful error catching mechanism which will act on every data row on most of the transformations, sources, and destinations. When a transformation hits an error on one or more specific data rows, those rows will be caught and we can develop scenarios on how to deal with those rows.

Most of the sources, ...

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