Did you know? SQL Server 2008 includes Cache Transform screencast

SQL Server 2008 includes Cache Transform:

The Cache Transform transformation writes data from a connected data source in the data flow to a Cache connection manager.  The cache can be populated from text files, XML files, Excel files, etc.; you are not limited to only populating the cache from an OLE DB source.  The Lookup transformation in a package performs lookups on the data using the Cache connection manager.

You can configure the Cache connection manager to save the data to a cache file (.caw).  The cache file can be populated once and reused throughout the ETL process within multiple Lookup transformations for performing surrogate key lookups and populating the data warehouse.

Read more about this in the SQL Server 2008 BOL ‘Cache Transform’.

Check out a screencast about the new cache transform transformation feature in SQL Server 2008  here.

Did you know? SQL Server 2008 includes Cache Transform from Dan English on Vimeo.

If you are interested in additional information in regards to this topic check out these other blog postings and sites: 

• http://www.sqlskills.com/blogs/stacia/2007/10/17/SQLServer2008LookupTransformationAndCaching.aspx
• http://blogs.conchango.com/jamiethomson/archive/2007/11/16/Katmai_3A00_-SSIS_3A00_-Lookup-component-gets-a-makeover.aspx

You can also check out a video on YouTube done by Jamie Thomson in regards to this new transformation here.  The last time I viewed it there wasn’t any audio, just video.

You can download the SSIS samples from CodePlex and take a look at a sample utilizing the cache transform here.