Getting started with ssis

SSIS 2005 Installation

To get SSIS working for a SQL Server 2005 environment

  1. Acquire SQL Server 2005 (x86 or 64 bit) images.
  2. Mount the second disk and launch the installation wizard
  3. “Next” your way through the dialogs until you see see this screen. Business Intelligence Development Studio
  4. Under Client Components, ensure Business Intelligence Development Studio is selected
  5. Continue clicking Next until the installation is complete.

You will now have BIDS (Business Intelligence Development Studio) on your machine with the correct project types so that you can create Integration Services, Analysis Services and Reporting Services projects. BIDS uses a Visual Studio 2005 shell.