Welcome to PC Teach Me...

Free Computer Training Videos.

Although you do not need to register to access this site. Registering has its benefits. Such as:

  • Access to training material associated with the video you are watching [if applicable]
  • Automatic email updates when new training videos are available.
  • Ask for a training video.
  • Exclusive access to pose questions to me [limited availability as I am doing this for free :-)].
  • Free contribution of your own training topics, this includes referencing your videos outside of PC Teach Me.
  • Its Free!

Member Login

Lost your password?

Not a member yet? Sign Up!

By registering with this blog you are also agreeing to receive email notifications for new posts but you can unsubscribe at anytime.

25425 Registered Users
71 Number Of Articles
Free Video Tutorials (Email) Free Video Tutorials (RSS) Free Video Tutorials (Twitter) Free Video Tutorials (Flickr)

SSIS: Data Viewers

Part of Microsoft Integration Services

ssis SSIS: Data ViewersSSIS: Data Viewers

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!

Debugging Data in SSIS With Data Viewers

Well take a deep breath and relax, because with the use of Data Viewers inside Microsoft Integration Services(SSIS) you can quickly pinpoint the pesky blighter.  Finding the core problem is easy but fixing is something else!  Data Viewers won’t 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 SSIS 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 is one of many SSIS tutorials on this site click here for more.

Example SSIS File

This video shows a full designed SSIS package which you can follow along. You will need to download the following file and run the install script which will attach the example database were using.  Simply run the executable and install to “C:” this will add a folder on your root called “PCTeachMe”.  You then need to run the “install” script within the folder of the same name and then finally ensure you have added your admin account to the database through SSMS.  So what are you waiting for click here to download: [/blockquote_left]

Related Posts

86 Comments

  1. PCTeachME says
    15 Feb 12 at 11:18am

    Thanks for the feedback

  2. PCTeachME says
    15 Feb 12 at 11:18am

    [..YouTube..] Thanks for the feedback

  3. PCTeachME says
    15 Feb 12 at 11:18am

    [..YouTube..] @kakkireniyt Thanks for the feedback

  4. kakkireniyt says
    14 Feb 12 at 2:48pm

    Very nice demo..Thanks for posting..

  5. 14 Feb 12 at 2:48pm

    [..YouTube..] Very nice demo..Thanks for posting..

  6. PCTeachME says
    24 Aug 11 at 11:35am

    Hi Goingy! Good luck with the exams, if there is any practical videos you think can help give me a shout and will try to rummage one up :)

Leave a Comment

You must be logged in to post a comment.

Valid XHTML 1.0 Transitional website security