SQL Server 2005 – Integration Services

Microsoft SQL Server 2005 Integration Services (SSIS) is a platform for building high performance data integration solutions, including the extraction, transformation, and loading (ETL) of packages for data warehousing. SSIS is the new name assigned to the component formerly branded as Data Transformation Services (DTS).

SQL Server 2005 – Integration Services

Integration Services InfoCenters

InfoCenters are navigation topics in the SQL Server 2005 Books Online that link to the information that is most important for people working with Integration Services in different roles.

Getting Started

Find Integration Services overviews, system requirements, installation instructions, and more.

Migrating DTS Packages to Integration Services, by SQL Server MVP Brian Knight

Planning and Architecture

Use these articles and whitepapers to better understand Integration Services and plan to use it to extract, transform, and load your data.

Development

Find the information developers require to build Integration Services packages and then use the packages to extract, transform, and load data.

Deployment

Plan for the deployment of your Integration Services packages.

Security and Protection

Learn how to handle security in SQL Server 2005 Integration Services packages.

Operations

Learn about SQL Server 2005 Integration Services administration and operations tasks such as executing packages and setting package properties.

Technical Reference

Find the documentation that covers the behavior of SQL Server 2005 Integration Services.