Using Data Viewers in SSIS

Well known author and speaker Brian Knight shows you how to use Data Viewers in SSIS (Integration Services) to view data when your are debugging your SSIS packages.

Duration:	4 mins 13 secs
Skill Level:	200
Rating:	4.42 out of 5
Publish Date:	December 01, 2008

Watch Video Now Watch it later!

12345
1=Poor, 3=Good, 5=Excellent

About the Author

Owner of Pragmatic Works :: Brian Knight, SQL Server MVP, MCSE, MCDBA, is the co-founder of Jumpstart TV and SQLServerCentral.com. Brian has written and co-written 9 technical books. Brian has spoken at conferences like PASS, TechEd and Connections. Brian develops solutions with Pragmatic Works to migrate DTS packages to SSIS.

References

There are no downloads or recommended reading links for this video

Comments

Farhan Sabzaali on 12/26/2008

Great presentation - thank you,

Michael Prendergast on 12/29/2008

Excellent feature. Very useful.

Saritha on 12/30/2008

Not able to see the video.

Don on 1/5/2009

Useful information I had not previously known

Jan on 1/5/2009

I'd like more information at the beginning of speaking.

Ed Svastits on 1/6/2009

Great tip. Good explanation.

Julie Moseley on 1/7/2009

that is exactly what i needed!

sara on 1/22/2009

very nice:-)

Tariq Bilal on 1/22/2009

fantastic!! never new it existed. Thanks Brian. You are a star*. :).

Venkata Taduri on 2/9/2009

Phenomenal video.. Thank you

Robert Fidelman on 2/17/2009

I noticed that there is no 'Data Viewer' option in a control flow, just the data flow. Is there an equivalent method for control flows? RAF

Wil Sisney on 3/16/2009

The presentation on Data Viewers is extreemly helpful! I'm glad I watched it!

Wil Sisney on 3/16/2009

The presentation on Data Viewers is extreemly helpful! I'm glad I watched it!

surya kiran on 5/21/2009

Gained some knowledge, Thank You

Carney Clegg on 6/22/2009

Thanks for sharing this video...

vasu contact on 7/12/2009

Little confusing at the end. It was made clear that dtexec is not imapcted and running from VS/BIDS use the dataviewers but NOT clear what happens when using the dtexecui separately. Not a big deal because anyone can try and see what happens.

Ram on 7/13/2009

Try to publish more and more of SSAS videos

James Moore on 7/22/2009

Cool, I had no idea data viewers even existed. Thanks, Brian!

Kevin Herr on 9/2/2009

Great presentation.

Shashi on 11/29/2009

Excellent video. It could save a lot of people a lot of time. Thanks.

Thomas Kelley on 12/31/2009

Beautiful!

Neelam on 1/2/2010

good