Did you know? SQL Server 2008 includes Cache Transform

Video Title :	Did you know? SQL Server 2008 includes Cache Transform
Description :	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.
Views :	2330
Rating :	4.60
Keywords, Tags :	SQL DYN Screencast SSIS Magenic
Video Length :	7 : 5

Congratulations for the video training. Greetings from Venezuela, guy.