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

Data Tap

Those who normally use the data viewer (to identify the records that go along the pipeline) will be now surprised. In this new version, it's possible to have data viewers dynamically created without having to open and edit a particular package. This type of data viewer is named Data Tap and is one of the best features included in this release. During a batch package execution, it is possible to identify the records that are flowing between any components under any Data Flow Task.

This new feature is just available in the Project Deployment Model approach, because the data stored from the Data Tap is stored in SSISDB Catalog.

Getting ready

To get started with this recipe, follow these steps:

  1. Open SQL Server Data Tools (SSDT).
  2. Add a new SSIS ...

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