Microsoft Sql Server 2008 Integration Services ... Link

: Take advantage of the shared lookup cache feature in SQL Server 2008 to speed up parallel pipelines.

: In your data sources, only SELECT the columns you actually need to save memory and bandwidth. Microsoft SQL Server 2008 Integration Services ...

A typical development "piece" or project follows these steps: : Take advantage of the shared lookup cache

: Use the Control Flow tab to define the overall workflow. This includes adding tasks like Execute SQL , FTP tasks, or Send Mail tasks, and connecting them with precedence constraints. This includes adding tasks like Execute SQL ,

: Where data is coming from (e.g., OLE DB, Flat File).

: If the SSIS service and SQL Server are on the same machine, use the SQL Server destination instead of OLE DB for significantly better performance.

SQL Server Integration Services (SSIS) Part 1 - Getting Started