SqlShare.com Logo
 
Skip Navigation Links
Home
Video List
Classes
About Us
Login / Register
Subscribe RSS Feed 

Idera Virtual Database

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.

Duration:
3 mins 39 secs
Skill Level:
100
Rating:
4.10 out of 5
Publish Date:
April 15, 2009
SSIS Lookup Transform Basics Watch Video Now  Watch it later!
Bookmark and Share
 
1=Poor, 3=Good, 5=Excellent

About the Author

Image of Tim Mitchell
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.

References



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

iandi on 2/10/2010
short and clear!! very good!

maddy on 2/20/2010
Really helpful ...

Charlie Bruno on 2/23/2010
Good example, simple but to the point.

Raj on 3/6/2010
Good video for basic

yeskay on 3/18/2010
nice..

Arun on 3/21/2010
good for beginners

babbu on 3/23/2010
good example for begginers...

Prasad on 5/5/2010
good

Venkata on 5/18/2010
Very nice

Anil Inampudi on 5/20/2010
gud one

Rudy on 5/26/2010
great video

Javid Khan on 6/1/2010
Simple but Complete

Raj Deep Alapati on 6/7/2010
These are 2 good videos for once who want to know straight about the feature and webcast abou the feature

Kris Robinett on 6/15/2010
Nice and simple. thnx

Ram on 6/15/2010
Not in detail

John on 6/17/2010
It was a bit short. Needed a little more explanation of what's actually happening and what's been output.

sridhar on 6/30/2010
Good One

ryan on 7/1/2010
Very nice! Thanks for taking the time to make this video.

Mark Gelatt on 7/30/2010
Good start, but need to know how to preserve 100% of the input rows in the output. This appears to be an INNER JOIN which will cause some records to be lost.

Don Gilman on 8/20/2010
Too brief. Needed to show results and needed to show the discarded records.



Must Be Logged In
 

How Do I Become a Video Author? |  Newsletter History

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