Installing SQL Server Integration Services
Step 1: Preparing to Install Integration Services
Before you install Microsoft SQL Server 2005 Integration Services (SSIS), review the following requirements:
- Hardware and Software Requirements for Installing SQL Server 2005
- Check Parameters for the System Configuration Checker
- Security Considerations for a SQL Server Installation
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
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 Setup information that is specific to Integration Services.
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.
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 |
|---|---|
General information about side-by-side installation and package migration. |
|
Information about the Package Migration Wizard and the differences between SQL Server 2000 Data Transformation Services and Integration Services packages. |
|
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 |
|---|---|
General information about side-by-side installation and package migration. |
|
Information about the Package Migration Wizard and the differences between SQL Server 2000 Data Transformation Services and Integration Services packages. |
|
Information about support for SQL Server 2000 Data Transformation Services in Integration Services. |
Change History
| Release | History |
|---|---|
17 July 2006 |
|
5 December 2005 |
|