Lookup and Cache Transform in SSIS

Details
Share
Attachments

Content: Video (mp4) - 10.65MB
Title: Lookup and Cache Transform in SSIS	Description: A look at how the cache transform can help you when having to perform the same lookup more than once using SSIS.
Date: 5/14/2010 12:00 AM	Author: Allan Mitchell

Share URL:
Copy and paste this URL to share content with viewers. For example, paste into email or instant messages.

Embed on your page:
Copy and paste this HTML to embed this content into a web page or blog.

<!-- copy and paste. Modify height and width if desired. -->
       <object id="scPlayer"  width="1024" height="786" type="application/x-shockwave-flash" data="http://content.screencast.com/users/SQLServerFAQ/folders/Cuppa%20Corner/media/c2d84f12-7c67-453d-a971-c72f7e57d532/mp4h264player.swf" >
<param name="movie" value="http://content.screencast.com/users/SQLServerFAQ/folders/Cuppa%20Corner/media/c2d84f12-7c67-453d-a971-c72f7e57d532/mp4h264player.swf" />
<param name="quality" value="high" />
<param name="bgcolor" value="#FFFFFF" />
<param name="flashVars" value="thumb=http://content.screencast.com/users/SQLServerFAQ/folders/Cuppa%20Corner/media/c2d84f12-7c67-453d-a971-c72f7e57d532/FirstFrame.png&containerwidth=1024&containerheight=786&showstartscreen=true&showendscreen=true&loop=false&autostart=false&color=1A1A1A,1A1A1A&thumb=FirstFrame.png&thumbscale=45&content=http://content.screencast.com/users/SQLServerFAQ/folders/Cuppa%20Corner/media/c2d84f12-7c67-453d-a971-c72f7e57d532/Lookup%20and%20Cache%20Transform%20in%20SSIS.mp4&blurover=false" />
<param name="allowFullScreen" value="true" />
<param name="scale" value="showall" />
<param name="allowScriptAccess" value="always" />
<param name="base" value="http://content.screencast.com/users/SQLServerFAQ/folders/Cuppa%20Corner/media/c2d84f12-7c67-453d-a971-c72f7e57d532/" />
<iframe type="text/html" frameborder="0" scrolling="no" style="overflow:hidden;" src="http://www.screencast.com/users/SQLServerFAQ/folders/Cuppa%20Corner/media/c2d84f12-7c67-453d-a971-c72f7e57d532/embed" height="786" width="1024" ></iframe>
</object>

<!-- copy and paste. Modify height and width if desired. -->
 <object id="scPlayer"  width="1024" height="786" type="application/x-shockwave-flash" data="http://content.screencast.com/users/SQLServerFAQ/folders/Cuppa%20Corner/media/c2d84f12-7c67-453d-a971-c72f7e57d532/mp4h264player.swf" >
 <param name="movie" value="http://content.screencast.com/users/SQLServerFAQ/folders/Cuppa%20Corner/media/c2d84f12-7c67-453d-a971-c72f7e57d532/mp4h264player.swf" />
 <param name="quality" value="high" />
 <param name="bgcolor" value="#FFFFFF" />
 <param name="flashVars" value="thumb=http://content.screencast.com/users/SQLServerFAQ/folders/Cuppa%20Corner/media/c2d84f12-7c67-453d-a971-c72f7e57d532/FirstFrame.png&containerwidth=1024&containerheight=786&showstartscreen=true&showendscreen=true&loop=false&autostart=false&color=1A1A1A,1A1A1A&thumb=FirstFrame.png&thumbscale=45&content=http://content.screencast.com/users/SQLServerFAQ/folders/Cuppa%20Corner/media/c2d84f12-7c67-453d-a971-c72f7e57d532/Lookup%20and%20Cache%20Transform%20in%20SSIS.mp4&blurover=false" />
 <param name="allowFullScreen" value="true" />
 <param name="scale" value="showall" />
 <param name="allowScriptAccess" value="always" />
 <param name="base" value="http://content.screencast.com/users/SQLServerFAQ/folders/Cuppa%20Corner/media/c2d84f12-7c67-453d-a971-c72f7e57d532/" />
 Unable to display content. Adobe Flash is required.
</object>

Content size: width: px height: px reset

Unable to Share Private Content