|
Comments
|
|
Great for novice
|
|
|
Good
|
|
|
Great beginner lession for SSIS controls
|
|
|
Hi,
where is the failure rows, is it in destination source or cache
|
|
|
Hi,
where is the failure rows, is it in destination source or cache
|
|
|
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.
|
|
|
thx for updating it
|
|
|
great!
|
|
|
Sound quality was poor, could not hear most of it. That said it prevents me from getting anything out of this one.
|
|
|
a good video
|
|
Bill Nicolich on
7/22/2009
Well-presented.
|
|
|
I like it
|
|
|
Thanks Tim, that made perfect sense.
|
|
|
good
want to know more about lookup so plz post some more video on it
|
|
|
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.
|
|
|
I could not hear the video even with the volumn turned up. It may just be my computer. I'll try again later.
|
|
|
We need more info on lookup, like if we want to add unmatched records to seprate table.
|
|
|
Simple example, big results. Need more and more of these!!!
|
|
|
very good
|
|
|
Speak louder!
I turn on max volume and barely hear it.
|
|
|
Does what it says on the tin thanks
|
|
|
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
|
|
|
can't hear it....useless video
|
|
|
great
|
|
|
Didnt show how the actual transformation had come out in the destination table
|
|
|
very nice explanation
|
|
|
I LOVE THIS VIDEO
|
|
Chyld Medford on
10/28/2009
Great video!
|
|
|
Need to describe more options
|
|
|
Just what I needed
|
|
|
Good.. but error output is not covered..
|
|
|
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.
|
|
|
Super
|
|
|
good one.
|
|
|
super Video
|
|
|
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.
|
|
|
nothing
|
|
|
short and clear!! very good!
|
|
|
Really helpful ...
|
|
Charlie Bruno on
2/23/2010
Good example, simple but to the point.
|
|
|
Good video for basic
|
|
|
nice..
|
|
|
good for beginners
|
|
|
good example for begginers...
|
|
|
good
|
|
|
Very nice
|
|
Anil Inampudi on
5/20/2010
gud one
|
|
|
great video
|
|
|
Simple but Complete
|
|
|
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
|
|
|
Not in detail
|
|
|
It was a bit short. Needed a little more explanation of what's actually happening and what's been output.
|
|
|
Good One
|
|
|
Very nice! Thanks for taking the time to make this video.
|
|
|
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.
|
|
|
Too brief. Needed to show results and needed to show the discarded records.
|
|
|
The video is not working.
|
|
Nitin Mistry on
10/27/2010
no too bad but the videos need to be larger in size (eg: 800 x 600 would work very well served from Amazon Cloud - we serve all our 1024 x 768 size videos from the cloud and it super fast and our viewers love it!
|
|
|
Too Short
|
|
|
ok ok video
|
|
|
Just the info I wasw looking for on this feature
|
|
|
Fine .........
|
|
|
This video demonstrates the Lookup Full Cache feature implemented in SQL Server 2008. http://technet.microsoft.com/en-us/sqlserver/ff686908.aspx
|
|
|
It should have been in little more detail.
|
|
|
Nice vedio!! How the failed records will be tracked?
|
|
|
The video is excellent except for a glaring omission. You never explain what you have accomplished! Did the lookup transform create a temp table with the vals from the flat file substituted and then these get used to replace existing rows in the db or did you insert new rows?
|
|
|
very Good.. this is a great site
|
|
|
Great Video Tim, I have worked with DTS extensively and now trying to learn SSRS; It helped me a lot !!!
|
|
|
Great Video Tim, I have worked with DTS extensively and now trying to learn SSRS; It helped me a lot !!!
|
|
|
How about providing links to continued videos? Presenter mentioned he'd be addressing missed matches in a later video, but now I have to try to find where that 2nd video is.
|
|
|
good one
|
|
|
great
|
|
|
good
|
|
|
good
|
|
|
good intro to Lookup Transforms
|
|
|
good
|
|
|
Nice..
|
|
|
Good
|
|
Danny Costello on
12/21/2011
Nice intro to Lookups, looking forward to seeing what to do with the lokup mismatches
|
|
Robert Gibson on
12/21/2011
Would have loved to see the results after the transformation by opening the destination table.
|
|
|
A "so what" video.
|
|
|
Good intro, but I also would have liked to see the results vs the input values to understand what rows were dropped & why.
|
|
|
As a result I cleaned up some of the lookups I had been using in a small project, although real time profit will be to small to notice.
|
|
|
The volume is too low.
|
|
|
Too simple
|
|
Tahir A. Syed on
12/21/2011
Great, should explain how to write those rejected data in the reject table. Thanks...
|
|
Mike Fieldman on
12/21/2011
Excellent!
|
|
|
Great and clear explanation on how to use the components
|
|
|
It looks like the database destination is being used both for a lookup to one table and insert into a different table. Is this correct?
|
|
|
I still have no idea what you are trying to show us. What was the end result? You just showed us HOW to do something but not exactly why we would really want to use this.
|
|
|
I would like to have seen more but this was a good beginning.
|
|
David Overall on
12/23/2011
Thanks for showing this useful component of SSIS
|
|
Juan Rivero on
12/26/2011
Tells how to hook up to other components but does not explain what the purpose of this Lookup component is.
|
|
Kris Robinett on
12/29/2011
I would have like to seen output that was sent to the OLE DB destination.
|
|
|
Excellent video
|
|
|
Very Good Video
|
|
|
Good One...But I'm not able to figure which table to be used as source table and which table as reference table and it is not clear that to which table the data is updated...Little more detail on these would have been more helpful
|
|
|
great video with explanation
|
|
|
excellent work.keept it up
|