Summary
Keywords
Full Transcript
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching! By Andy Brown https://www.wiseowl.co.uk - Lookup transforms are where Integration Services starts getting fun! They allow you to import sets of data, matching a particular column's value against a "lookup table" and storing the corresponding record id. Not only that, but you can customise what happens when a matching lookup record isn't found, and also use cache transforms to speed up access to your lookup table. If you like the style of our tutorials but think that there is no substitute for classroom training, we agree with you! Have a look at our two-day SSIS introductory course at https://www.wiseowl.co.uk/courses/ssis.htm (we'll consider running this in countries outside the UK, although this won't be a cheap option).
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.
