Did you know? SQL Server 2008 includes Cache Transform

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,

Read more...