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
SSIS Installation Problem
Hot Topic
- ERROR: A variable may only be added once to either the read lock list or the write lock list.
- surface area configuration won't run
- SQL Express with the WDK DTM?
- Error locating server/instance specified
- SQL server upgrade hardware.
- Help! getting errors when trying to connect to SQL Server Management Studio
- Creating a double entry book keeping system
- Missing a needed using statement but not sure which one
- mdac upgrade
- varchar (max) - is this correct
SQL Server
- Snakebit!
- Error: Attribute key cannot be found
- Custom procs for replication
- ROM on SQL 2005 replication
- How can we deal with unknown member in cubes for data mining?
- Instructions for setting up a Sybase ASE Server as a SQL Server 2005 Linked Server?
- SQLGetData returns an empty buffer on Query (ODBC)
- SQLmail TEST failed
- Cannot create a connection to data source !!!! SSRS 2005
- filtering on dataset
SSIS Installation Problem
Guido den Broeder
http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=95&SiteID=1
m.hwang
Have you tried to (re)install SSIS by using the Setup GUI instead of the command line
Quite a lot of SQL components install at least bits and pieces of SSIS...the Import and Export Wizard and its dependencies, for example. But I don't know what Setup is checking to determine that SSIS is already installed. The REGMON tool might be useful in troubleshooting this.
-Doug
wertasdff
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