Initial Installation (Integration Services)
SQL Server Integration Services is installed through the SQL Server 2008 Setup program. You can install Integration Services alongside other SQL Server components or you can install Integration Services as a stand-alone component. Integration Services includes both client and server applications.
To use a dedicated server for extraction, transformation, and loading (ETL) processes, we recommend that you install a local instance of the SQL Server Database Engine when you install Integration Services. Integration Services typically stores packages in an instance of the Database Engine and relies on SQL Server Agent for scheduling those packages. If the ETL server does not have an instance of the Database Engine, you will have to schedule or run packages from a server that does have an instance of the Database Engine. This means that the packages will not be running on the ETL server, but instead on the server from which they were started. As a result, the resources of the dedicated ETL server are not being used as intended. Furthemore, the resources of other servers might be strained by the running ETL processes.
To get started, review the following items, find the item that best matches your objective, and then click the corresponding link for more information:
Read about hardware and software requirements, or learn more about components in SQL Server. For more information, see Hardware and Software Requirements for Installing SQL Server 2008 R2 and Editions and Components of SQL Server 2008 R2.
Learn about the options that you have to select when you install Integration Services. For more information, see Considerations for Installing Integration Services.
Install Integration Services. For more information, see How to: Install SQL Server 2008 R2 (Setup) or How to: Install SQL Server 2008 R2 from the Command Prompt.
After you install Integration Services, you can do the following steps:
Verify that installation succeeded by starting SQL Server Management Studio and connecting to the newly-installed Integration Services service.
Use the tutorials to learn basic skills for building packages.
Download and install Integration Services samples to learn about combining tasks, sources, transformations, and destinations to build useful packages.
The following sections provide instructions for performing these steps.
Verify the Installation
To verify your installation of Integration Services, start SQL Server Management Studio and connect to the newly-installed Integration Services service.
To connect to Integration Services
Click Start, point to All Programs, point to Microsoft SQL Server, and then click SQL Server Management Studio.
In the Connect to Server dialog box, select the following options:
In the Server type list, select Integration Services.
In the Server name box, enter a server name.
Make sure to enter a computer name, not the name of an instance of the SQL Server Database Engine. The service is not specific to a particular instance of the Database Engine. You connect to the service by using the name of the computer on which the service is running.
SQL Server Management Studio opens. By default, the Object Explorer window is open and positioned in the lower-left corner of the development environment. If Object Explorer is not open, on the View menu, click Object Explorer.
Run the Tutorials
To learn basic skills for building packages, you can step through these tutorials that are included with Integration Services:
To obtain the sample data files that the tutorials use, together with the completed packages that you can use to check your work, download the samples, as described in the next section.
Download the Samples
In SQL Server 2008, you can download and install the AdventureWorks2008R2 sample database, the Integration Services sample packages, and the Integration Services programming samples from the Microsoft CodePlex site.
To download the Integration Services samples
Open a browser window, and either type http://www.CodePlex.com, or click SQL Server Samples to go directly to the Microsoft SQL Server Samples and Community Projects portal page.
On the page, find Microsoft SQL Server Product Samples.
On the Release tab, find the version of the AdventureWorks2008R2 database that you want to use:
To download the Setup program for the AdventureWorks2008R2 OLTP database that provides data for some Integration Services sample packages, select AdventureWorksDB.msi. (If you are using 64-bit or Itanium-based operating systems, select AdventureWorksDBx64.msi or AdventureWorksDBIA64.msi.)
To download the Setup program for the AdventureWorks2008R2 data warehouse database, select AdventureWorksBI.msi. (If you are using 64-bit or Itanium-based operating systems, select AdventureWorksBIx64.msi or AdventureWorksBIIA64.msi.)
To use the AdventureWorks2008R2 data warehouse database, you must have SQL Server Analysis Services installed.
On the Microsoft SQL Server Product Samples page, click Integration Services.
On the Release tab, download the SQL Server Samples Setup program, and then run Setup on your computer.
You must install all the samples. There is not a separate Setup program for Integration Services.