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.
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.