Monday 9 May 2016

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.

No comments:

Post a Comment

If you have any doubt, please let me know.

Popular Posts