The Cache Transformation allows you to build up your lookup cache before you need it, saving you a step or two in the process. The Lookup transformation in SSIS has changed a lot in SQL Server 2008.

In SQL Server Integration Services (SSIS) Packages, expressions are everywhere. You may have worked with expressions in some of the transformation tasks, such as the Derive Column Transformation, but ...

eWEEK content and product recommendations are editorially independent. We may make money when you click on links to our partners. Learn More. Aiming to unsnarl database administrators jobs, Microsoft ...