SqlShare.com Logo
 
Skip Navigation Links
Home
Channels
Classes
About Us
Login / Register
Subscribe to the All channels feed  Goto the SqlShare.com blog
Image of Tim Mitchell
Author:

Author Bio:
Tim Mitchell is a Microsoft SQL Server database developer, business intelligence consultant, writer, and speaker. He has been working professionally with SQL Server for over six years, and holds the MCTS and MCDBA certifications from Microsoft as well as a Bachelor's degree in computer science from Texas A&M University - Commerce.
SSIS Lookup Transform Basics

SSIS Lookup Transform Basics

The SSIS lookup transform is a great way to convert a literal like 'Florida' to something more database friendly like 'FL'. It's easy to use! Join SSIS expert Tim Mitchell for a simple demonstration of how to use this transform.

Video Information
Publish Date:
April 15, 2009
Length:
3:39
Skill Level:
100
Rating:
4.12 out of 5

You must be logged in to view this video.    

Bookmark and Share

  Rate This Video:  
 
1=Poor, 3=Good, 5=Excellent
Comments:
Dilli on 4/22/2009
Great for novice

syed on 4/28/2009
Good

carollin on 6/19/2009
Great beginner lession for SSIS controls

Gökdal on 6/24/2009
Hi, where is the failure rows, is it in destination source or cache

Gökdal on 6/24/2009
Hi, where is the failure rows, is it in destination source or cache

Jerry Loyd on 6/24/2009
Still can't get this Xform (Lookup) to work, but it's probably some stupid little thing. I had no idea how to even start without this video.

vishal on 7/5/2009
thx for updating it

Allen on 7/17/2009
great!

Jerry on 7/22/2009
Sound quality was poor, could not hear most of it. That said it prevents me from getting anything out of this one.

John O'Sullivan on 7/22/2009
a good video

Bill Nicolich on 7/22/2009
Well-presented.

Halomoan on 7/22/2009
I like it

David Stein on 7/22/2009
Thanks Tim, that made perfect sense.

Priyadarshan Patil on 7/22/2009
good want to know more about lookup so plz post some more video on it

eirc on 7/22/2009
Should have included more information regarding the lookup data flow and what it actually did. Didn't seem like a basics video .. informative none the less.

Cynthia Gonzales on 7/22/2009
I could not hear the video even with the volumn turned up. It may just be my computer. I'll try again later.

punjwani on 7/22/2009
We need more info on lookup, like if we want to add unmatched records to seprate table.

John R deCoville on 7/27/2009
Simple example, big results. Need more and more of these!!!

Arturo on 7/28/2009
very good

Ted Quan on 7/28/2009
Speak louder! I turn on max volume and barely hear it.

vin lawrence on 8/1/2009
Does what it says on the tin thanks

vince diana on 8/14/2009
in general the audio level is too low...i have it on max and it's hard to hear...thanks and all the best to you

ted on 9/18/2009
can't hear it....useless video

sam on 9/28/2009
great

Karthik Gunasekar on 10/2/2009
Didnt show how the actual transformation had come out in the destination table

sunil on 10/22/2009
very nice explanation

Jamir on 10/24/2009
I LOVE THIS VIDEO

Chyld Medford on 10/28/2009
Great video!

krishan on 11/10/2009
Need to describe more options

Magnus on 11/12/2009
Just what I needed

R on 11/17/2009
Good.. but error output is not covered..

fabrizio la torre on 11/23/2009
it would have been interesting to add directly the part that will explain how unmatched rows are managed

Shane Moroney on 12/8/2009
Good introduction.

Chandhini on 12/24/2009
Super

Neelam on 1/2/2010
good one.

Marcel on 1/19/2010
super Video

Wenda Stephens on 2/2/2010
This is a good start.. I guess for me I am trying to figure out how to use the lookup for choosing whether to add or update records based on if found or not in the destination file. So I guess I would have liked to have seen one more piece with it working with the failed records.. But I think it is a small extra step which wont be too much of a jump.

gopi on 2/9/2010
nothing



Must Be Logged In

References
Supporting Code

Sponsored Ads
 

How Do I Become a Video Author? |  Newsletter History

Copyright © Fourdeuce, Inc., 2005-2009. All Rights Reserved | Privacy Policy | Terms & Conditions