Installing SQL Server Integration Services

Switch on low bandwidth view

Community Content

In this section

Statistics Annotations (0)

Click here to expand

Collapse All

SQL Server 2005 Books Online (November 2008)

Installing SQL Server Integration Services

Updated: 17 July 2006

Step 1: Preparing to Install Integration Services

Before you install Microsoft SQL Server 2005 Integration Services (SSIS), review the following requirements:

Note:
SQL Server 2005 Integration Services does not provide special installation options for a failover cluster. However, after installing Integration Services separately on each node of a cluster, you can manually configure it to operate as a clustered service. For more information, see Configuring Integration Services in a Clustered Environment.

Step 2: Installing Integration Services

After you review the installation requirements for SQL Server 2005 and ensure that your computer meets those requirements, you are ready to install Integration Services. Depending on your environment, you will install Integration Services in one of the following ways:

Installing Integration Services on a Clean Computer
Adding Integration Services to an Existing Installation of SQL Server 2005
Installing Integration Services Side-by-Side with SQL Server 2000 Data Transformation Services
Upgrading to Integration Services

Note:
Some SQL Server 2005 components that you may select for installation on the Components to Install page or the Feature Selection page of the SQL Server Installation Wizard install a partial subset of Integration Services components. These components are useful for specific tasks, but the functionality of Integration Services will be limited. For example, the Database Engine option installs the Integration Services components required for the SQL Server Import and Export Wizard. The Business Intelligence Development Studio option installs the Integration Services components required to design a package, but the Integration Services service is not installed, the Message Queue task is not functional, and you cannot run packages outside of BI Development Studio. To ensure a complete installation of Integration Services, you must select Integration Services on the Components to Install page.

Note:

Some SQL Server 2005 components that you may select for installation on the Components to Install page or the Feature Selection page of the SQL Server Installation Wizard install a partial subset of Integration Services components. These components are useful for specific tasks, but the functionality of Integration Services will be limited. For example, the Database Engine option installs the Integration Services components required for the SQL Server Import and Export Wizard. The Business Intelligence Development Studio option installs the Integration Services components required to design a package, but the Integration Services service is not installed, the Message Queue task is not functional, and you cannot run packages outside of BI Development Studio. To ensure a complete installation of Integration Services, you must select Integration Services on the Components to Install page.

Note:
For information about SQL Server 2005 features installed on a 64-bit computer, see Integration Services Considerations on 64-bit Computers.

Installing Integration Services on a Clean Computer

As with any component of SQL Server 2005, you can install Integration Services either by running SQL Server Setup through the SQL Server Installation Wizard or by running the Setup program from the command prompt.

Option 1: Using the SQL Server Installation Wizard

You can install Integration Services on the local computer by using the SQL Server Installation Wizard.

Topic	Description
Installing SQL Server Integration Services by Using Setup	Setup information that is specific to Integration Services.
How to: Install SQL Server 2005 (Setup)	Setup information that describes each step of the SQL Server Installation Wizard, and is applicable to all components of SQL Server 2005, including Integration Services.

Option 2: Running the Setup program from the command prompt

You can run SQL Server Setup from the command prompt. You must run the Setup program from the command prompt when you install Integration Services on a remote computer.

Topic	Description
Installing SQL Server Integration Services from the Command Prompt	Command prompt setup information that is specific to Integration Services.
How to: Install SQL Server 2005 from the Command Prompt	Command prompt setup information that describes each step and option of the command prompt setup process, and is applicable to all components of SQL Server 2005, including Integration Services.

Adding Integration Services to an Existing Installation of SQL Server 2005

You can also add Integration Services to an existing installation of SQL Server 2005. For more information, see How to: Add Integration Services to an Existing Instance of SQL Server 2005.

Installing Integration Services Side-by-Side with SQL Server 2000 Data Transformation Services

You can install Integration Services side-by-side with Microsoft SQL Server 2000 Data Transformation Services (DTS). Later, you can optionally migrate existing DTS packages to the Integration Services package format while leaving the existing packages intact.

Topic	Description
Upgrading or Migrating Data Transformation Services	General information about side-by-side installation and package migration.
Migrating Data Transformation Services Packages	Information about the Package Migration Wizard and the differences between SQL Server 2000 Data Transformation Services and Integration Services packages.
SQL Server 2005 Integration Services Backward Compatibility	Information about support for SQL Server 2000 Data Transformation Services in Integration Services.

Upgrading to Integration Services

You can upgrade to Integration Services from Data Transformation Services by using SQL Server Setup to install Integration Services, and then optionally using the Package Migration Wizard to migrate your existing DTS packages to the new Integration Services package format while leaving the existing packages intact.

Topic	Description
Upgrading or Migrating Data Transformation Services	General information about side-by-side installation and package migration.
Migrating Data Transformation Services Packages	Information about the Package Migration Wizard and the differences between SQL Server 2000 Data Transformation Services and Integration Services packages.
SQL Server 2005 Integration Services Backward Compatibility	Information about support for SQL Server 2000 Data Transformation Services in Integration Services.

Change History

Release	History
17 July 2006	Changed content: Added section about adding Integration Services to an existing installation of SQL Server 2005.
5 December 2005	Changed content: Added notes directing users to topics on Integration Services cluster configuration and 64-bit features for more information.