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.

25426 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. oblax77 says
    19 May 11 at 3:01am

    bang! lol

  2. oblax77 says
    19 May 11 at 2:01am

    bang! lol

  3. PCTeachME says
    18 Nov 10 at 12:47am

    Thanks for the feedback

  4. PCTeachME says
    18 Nov 10 at 12:47am

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

  5. PCTeachME says
    18 Nov 10 at 12:47am

    @umair0001 Thanks for the feedback

  6. PCTeachME says
    18 Nov 10 at 12:47am

    @umair0001 Thanks for the feedback

  7. PCTeachME says
    18 Nov 10 at 12:47am

    @umair0001 Thanks for the feedback

  8. PCTeachME says
    18 Nov 10 at 12:47am

    @umair0001 Thanks for the feedback

  9. PCTeachME says
    18 Nov 10 at 12:47am

    @umair0001 Thanks for the feedback

  10. PCTeachME says
    18 Nov 10 at 12:47am

    @umair0001 Thanks for the feedback

  11. umair0001 says
    13 Nov 10 at 11:01pm

    Great vid. Thanks for posting.

  12. umair0001 says
    13 Nov 10 at 11:01pm

    [..YouTube..] Great vid. Thanks for posting.

  13. umair0001 says
    13 Nov 10 at 11:01pm

    [..YouTube..] Great vid. Thanks for posting.

  14. umair0001 says
    13 Nov 10 at 11:01pm

    Great vid. Thanks for posting.

  15. umair0001 says
    13 Nov 10 at 11:01pm

    Great vid. Thanks for posting.

  16. umair0001 says
    13 Nov 10 at 11:01pm

    Great vid. Thanks for posting.
    

  17. umair0001 says
    13 Nov 10 at 11:01pm

    Great vid. Thanks for posting.

  18. umair0001 says
    13 Nov 10 at 11:01pm

    Great vid. Thanks for posting.

  19. umair0001 says
    13 Nov 10 at 11:01pm

    Great vid. Thanks for posting.

  20. umair0001 says
    13 Nov 10 at 11:01pm

    Great vid. Thanks for posting.

1 2 3 5

Leave a Comment

You must be logged in to post a comment.

Valid XHTML 1.0 Transitional website security