The release of Microsoft® SQL Server 2005 introduced a new service called SQL Server Integration Services (SSIS). One of the struggles faced by database administrators and SQL developers is determining how this new release and new services affect their current hardware infrastructure and SQL Server database environment.

This white paper helps SQL Server users determine the appropriate amount and most cost-effective server/storage/management software infrastructure to meet their SSIS requirements.

Topics covered include:

• Best practice considerations for servers, storage, and management software
• Reference information and recommendations that can be applied to any SSIS environment
• Considerations for future application scaling
• Performance data related to scaling the SQL Server configuration
• SSIS packages and how they affect performance