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:
Open SQL Server Data Tools (SSDT).
Add a new SSIS project to open the SSIS solution and name the project R05_Data tap.
How to do it...
The next steps will explain how to create a simple Data Viewer under a data flow and then a Data Tap in the exact same location.
In Solution Explorer, locate the project...