Export (0) Print
Expand All

Installing SQL Server Integration Services

Updated: 17 July 2006

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

ms143731.note(en-US,SQL.90).gifNote:
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.

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:

ms143731.note(en-US,SQL.90).gifNote:
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.

ms143731.note(en-US,SQL.90).gifNote:
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.

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.

Community Additions

ADD
Show:
© 2014 Microsoft