SSIS - Data Viewers

Published: 13 September 2010
on channel: PCTeachME

4,905

We are slowly getting there! Our packages are coming along quite nicely but then DISASTER! You are getting errors all of sudden. After you have ran around the office screaming for 5 minutes and grabbed a cup of coffee you need to tackle this head on!

Well take a deep breath and relax, because with the use of Data Viewers inside Microsoft Integration Services you can quickly pinpoint the pesky blighter. Finding the core problem is easy but fixing is something else! Data Viewers wont show you how to fix the error, but will help you identify the source of the problem. This rather unused option by newbies is the key to becoming a pro! Once you have mastered these wonderful tools it will make you life so much easier.

What do they do? Well, they simply display your data with the confines of SSIS. If your doing string manipulation you can literally see the result of your transformation prior to SSIS throwing its toys out the pram! But is doesnt just end there, if the data your importing/transforming is an unknown entity for your warehouse you can use Data Viewers to highlight trends in your data too! Thus identifying new look-up tables you may need to incorporate.

So they are more than just a debug tool, they can be used to help you sulpt your transformations as you go.

This video shows a full designed package which you can follow along. You will need to download the file from PCTeach.Me

On this page of the site you can watch the video online SSIS - Data Viewers with a duration of hours minute second in good quality, which was uploaded by the user PCTeachME 13 September 2010, share the link with friends and acquaintances, this video has already been watched 4,905 times on youtube and it was liked by 11 viewers. Enjoy your viewing!

177

00:00:00