Get to Know the SSIS Lookup Transformation to Lookup Values in an Access 2007 DB, Part 2 - view details
In this video Scott will wrap up how to use a lookup transformation in order to join data from SQL Server and Microsoft Access.
Highlights from this video:Lookup transformation
Lookup transformation editor
Cache modeDetermining the connection type
Cache connection manager
How should you handle rows with no matching entries?
and much more Source: http://www.learnitfirst.com/Course/158/Video/2094/Pt2-Lookup-Transformation-for-Access.aspx Course: http://www.learnitfirst.com/Course/158/SSIS-2008.aspx Skill Level: 400 (Intermediate - Advanced) Length: 19:45 (34.9MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".
Keywords for this video: SSIS 2008, lookup transformation, lookup values, Access 2007, sql server 2008, caching, cache connection manager
This video comes from the SSIS 2008 online training course, SQL Server 2008 Integration Services. And be sure to check out even more SQL 2008 Integration Services training videos.
