Data Viewer in SSIS

The Data Flow Task moves data from sources to destinations with some help of transforms. Data viewer is a way where we can see the data while we dubbing the package. It is available in Data Flow Task. Data Viewers are containers that can contain a single SSIS buffer’s work.  As the data passes through the Data Path you are able to view what is in each buffer.  As each buffer passes into the Data Viewer, the processing of the SSIS package on that Data Path is paused. 

I have a Data flow task

 

For Enabling the Data Viewer Right click on the arrow.

 

Click on the Enable Data viewer

 

You will see the Magnifier icon. Click on this

 

Click on the Data viewer and select the column which you want to see.

Click ok.

 Now execute the package.

 

With the help of Data viewer we can see the value at the run time.

Note: - Before deploying the SSIS package please remove the Data Viewer.