How to use SSIS Data Viewer in DataFlow Task

In this post you will learn how to use SSIS Data Viewer to debug/troubleshoot SSIS DataFlow Pipeline issues at runtime. You can use SSIS Data Viewer any time you want to see what your data look like at given point in pipe line.

Note: For simplicity we have used Free DummyData Generator Source in this post rather than real Source.. Please download it from this link

How to add SSIS Data Viewer

  1. Right click on arrow between any two transform
  2. Click on “Enable Data Viewer” option. If you already have data viewer then it will show “Disable Data Viewer
  3. Run you SSIS Package or Just Data Flow task
  4. Now when Execution reaches to the point where you have data viewer you will see it as a Popup Form. You can dock it somewhere for easy view….
  5. For each Buffer passes data viewer will refresh data … You have to Click Green Play button to continue debug process.

SSIS Data Viewer - Debug Pipeline

SSIS Data Viewer – Debug Pipeline

SSIS Data Viewer - View Records at Runtime in Data Flow

SSIS Data Viewer – View Records at Runtime in Data Flow

 

Binary World is a Software Development company located in Atlanta, USA (since 2007). Binary World specialized in Business Intelligence, mobile, cloud computing and .Net Application Development.

Tagged with: , ,
Posted in SSIS