Installing SQL Server 2005 Integration Services

I tried removing and reinstalling SQL Server 2005 Developer Edition for three times, including "all-at-once" component installation and "component-by-component" and I just can't get Integration Services to install.

Here is the setting:
- I have WinXPPro SP2
- I had SQL2K and removed it
- I installed SQL2k5 (as described above)

I am getting the following error:

Microsoft SQL Server 2005 Integration Services -- A component that you have specified in the ADD_LOCAL property is already installed. To upgrade the existing component, refer to the template.ini and set the UPGRADE property to the name of the component.

This component of course is not installed. I believe it has to do something with the registry - when SQL2K was removed it didn't clean the registry. I tried with

setup /qb addlocal=SQL_DTS

and later with

setup /qb upgrade=SQL_DTS

w/o success.

Anyone any ideas

Thanks,

Ales

Answer this question

Installing SQL Server 2005 Integration Services

mark2741
If this helps, here is some additional info: I ran the Report and got the following list of components I have installed:

ALBATROS

The following components are installed on this server

MSSQLSERVER

Analysis Services

[Version: 9.00.1399.06 Edition: Developer Edition Patch level: 9.00.1399.06 Language: English (United States)]

Database Engine

[Version: 9.00.1399.06 Edition: Developer Edition Patch level: 9.00.1399.06 Language: English (United States)]

Reporting Services

[Version: 9.00.1399.06 Edition: Developer Edition Patch level: 9.00.1399.06 Language: English (United States)]

Common components

Workstation Components

[Version: 9.00.1399.06 Edition: Developer Edition Patch level: 9.00.1399.06 Language: English (United States)]

Since Integration Services is not on the list I am really lost.

Thanks again for your help,

Ales
svrid
I haven't seen this problem before - isn't it fun being the first one to hit something.

Try uninstalling SSIS from the command line: setup.exe /qb remove=SQL_DTS and let's see what happens.
BarryGA
I also got the same problem! and I also got MS SQL 2000 installed. I uninstalled this SQL2000 instance already, but no luck. Has anyone been able to find a solution for this issue cause it really is driving me nuts.
Dynamical Dog

This worked for me. I ran the program and noticed I still had the 2005 Express Edition Tools showing as installed. I removed the entry with the MSI Cleanup utility and was able to install the SQL 2005 Management Tools. I have been looking for this answer for at least three months now....

Thanks.
Landj68
I got the same problem. I tried your way. No luck. I also have SQL server 2000 installed. I thought its management tools and online help might have some registry conflict with SQL server 2005.
Trial and Error
Have you tried running the MSI Cleanup utility It could be that even though the components are no longer installed, MSI thinks they are, and therefore will not let you re-install them. You can get the MSICUU here ---> http://support.microsoft.com/default.aspx/kb/290301
Installing SQL Server 2005 Integration Services

Answer this question