O'Reilly logo

What's New in SQL Server 2012 by Jon Reade, Rachel Clements

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

Data taps

The last significant new feature of SSIS that we will look at is the data tap. A data tap literally "taps into" the data flow between SSIS tasks and writes it out to a .csv file.

This is very useful, especially in a production environment, as it allows a dump of the data passing between two SSIS tasks to be captured for analysis by a production, test, or development team if there is a production problem, without changing the SSIS package in the live environment.

This means the production DBA doesn't need to change the package (always a bad idea) and the developer doesn't have to be given access to the production machine in order to get the data they need to debug the process. Everyone wins, including the end users, as the system remains ...

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