THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Andy Leonard

Andy Leonard is CSO of Linchpin People and SQLPeople, an SSIS Trainer, Consultant, and developer; a Business Intelligence Markup Language (Biml) developer; SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of SQL Server 2012 Integration Services Design Patterns. His background includes web application architecture and development, VB, and ASP. Andy loves the SQL Server Community!
Note: Comments are moderated. Spam shall not pass! </GandalfVoice>

SSIS Snack: Grid Data Viewer

Introduction

SSIS Data Viewers are handy - very handy. I use them so much the Data Viewer link on my Data Flow Path context menu is showing signs of wear. I click on it that much.

Using the Grid Data Viewer

I'm starting with the Data Flow I built for SSIS Snack: The Trash Destination Adapter. The green arrow between the "Dummy Source" (OLE DB Source) and Trash Destination adapter is a Data Flow Path. Right-click it, and then click Data Viewers to open the Data Flow Path Editor:

 Click on the Add button to add a new data viewer. There are several types, accept the default Grid Type for this exercise:

 You can configure which columns appear in the Grid Data Viewer by clicking the Grid tab and selecting columns to view. Once configured, click the OK button and the close the Data Flow Path Editor. When you execute the Data Flow Task, the Grid Data Viewer will "pause" the data flowing through the data flow pipeline and display it in the grid data viewer:

 If you click the Copy button without clicking any rows, the contents of the data viewer will transferred to the clipboard. If you click rows first, only the selected rows will be copied. You can then open Excel and paste the rows - column headers and all - for more analysis:

Conclusion

Data viewers are an awesome troubleshooting utility for SSIS!

:{> Andy

 

Published Monday, March 08, 2010 8:00 AM by andyleonard
Filed under:

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Riemaxi said:

Hi Andy

I am using the dataviewer but I am not getting anything.

The flow executes very well, I see I get the data but the viewer never display.

Any thoughs?

October 3, 2011 5:21 AM
 

miu said:

Riemaxi: maybe you dont have any information in the flow.

August 14, 2014 5:09 PM
 

csrreddy said:

what is detach and attach

August 19, 2014 6:13 AM

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

My Company


Other Blog

Check out my personal blog...
http://andyleonard.me

Contact Me

Twitter: @AndyLeonard
Email: andy.leonard@gmail.com

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement