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: Lookups

ssis SSIS: LookupsSSIS: Lookups

When either importing data or ETL (Extract, Transform & Load) for a data warehouse, you quite often need to assign key values to your data so you can use these values to join/link on. For example, if you have a list of a spreadsheet which contains region information you may need to assign the region ID to the destination table. When the ID is present you can use this new key to join your data together. In the ETL world these quite often are referred to as a Surrogate keys as you are replacing the original text/ID with a new key of your choosing. There is another lookup known as a Fuzzy Lookup which is covered in a related video.

SSIS Lookups

This video will explore how to perform an SSIS lookup to 3 levels; Basic – a standard SSIS lookup, Intermediate – a SSIS Lookup with simple error handling & Advanced – a SSIS Lookup with transformation(fixing) of the errors.

This video is one of many SSIS tutorials on this site click here for more.

Example SSIS File

As this video discusses a topic that warrants an hour of time to explain, I have opted to create a series of example files (for SQL 2008) which can be obtained on the post. you can install and play around with all the permutations. These example files can be obtained here:

Follow the instruction on the begining of the video, if you get stuck read the “readme.txt” file for further assistance. Note you will need to add security login to the attached database to ensure the SSIS Packages work correctly

Related Posts

166 Comments

  1. PCTeachME says
    22 Aug 10 at 5:03am

    [..YouTube..] @rBuck50Suck Glad you like! Check out the Fuzzy Lookup video I also posted.

  2. PCTeachME says
    22 Aug 10 at 5:03am

    @rBuck50Suck Glad you like! Check out the Fuzzy Lookup video I also posted.

  3. PCTeachME says
    22 Aug 10 at 5:03am

    @rBuck50Suck Glad you like! Check out the Fuzzy Lookup video I also posted.

  4. PCTeachME says
    22 Aug 10 at 5:03am

    @rBuck50Suck Glad you like! Check out the Fuzzy Lookup video I also posted.

  5. PCTeachME says
    22 Aug 10 at 5:03am

    @rBuck50Suck Glad you like! Check out the Fuzzy Lookup video I also posted.

  6. PCTeachME says
    22 Aug 10 at 5:03am

    @rBuck50Suck Glad you like! Check out the Fuzzy Lookup video I also posted.

  7. PCTeachME says
    22 Aug 10 at 5:03am

    @rBuck50Suck Glad you like! Check out the Fuzzy Lookup video I also posted.

  8. PCTeachME says
    22 Aug 10 at 5:03am

    @rBuck50Suck Glad you like! Check out the Fuzzy Lookup video I also posted.

  9. PCTeachME says
    22 Aug 10 at 5:03am

    @rBuck50Suck Glad you like! Check out the Fuzzy Lookup video I also posted.

  10. PCTeachME says
    22 Aug 10 at 5:03am

    @rBuck50Suck Glad you like! Check out the Fuzzy Lookup video I also posted.

  11. PCTeachME says
    22 Aug 10 at 5:03am

    @rBuck50Suck Glad you like! Check out the Fuzzy Lookup video I also posted.

  12. PCTeachME says
    22 Aug 10 at 5:03am

    @rBuck50Suck Glad you like! Check out the Fuzzy Lookup video I also posted.

  13. PCTeachME says
    22 Aug 10 at 5:03am

    @rBuck50Suck Glad you like! Check out the Fuzzy Lookup video I also posted.

  14. PCTeachME says
    22 Aug 10 at 5:03am

    @rBuck50Suck Glad you like! Check out the Fuzzy Lookup video I also posted.

  15. PCTeachME says
    22 Aug 10 at 4:03am

    @rBuck50Suck Glad you like! Check out the Fuzzy Lookup video I also posted.

  16. rBuck50Suck says
    21 Aug 10 at 7:38pm

    Very nice!!

  17. 21 Aug 10 at 7:38pm

    [..YouTube..] Very nice!!

  18. 21 Aug 10 at 7:38pm

    Very nice!!

  19. 21 Aug 10 at 7:38pm

    Very nice!!

  20. 21 Aug 10 at 6:38pm

    Very nice!!

1 2 3 9

Leave a Comment

You must be logged in to post a comment.

Valid XHTML 1.0 Transitional website security