Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
zeeshan13
Constraint Violating Yak Guru
347 Posts |
 Posted - 2008-12-23 : 17:16:15
|
| Hi All,On my comany server; SQL Server 2005 is already installed and running. I wanted to install SSIS since it was missing on this server. Installing SSIS on my company server:I followed the steps listed on the following Microsoft support site:http://support.microsoft.com/kb/913967But got the following error:http://www.flickr.com/photos/7714646@N07/3131921260/sizes/o/When I click details I get the following:http://www.flickr.com/photos/7714646@N07/3131934038/sizes/o/Under SQL Managment Studio when I run the query SELECT @@version I got the following:Microsoft SQL Server 2005 - 9.00.3068.00 (Intel X86) Feb 26 2008 18:15:01 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2) I have the following operating install on this server:http://www.flickr.com/photos/7714646@N07/3131956586/sizes/o/I am using the same SQL 2005 installer that I used to install SQL Server 2005 on this server. Do you guys have any idea why I am unable to install SSIS on this server.Please help.Thanks. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-23 : 18:02:19
|
| You already have SQL Server installed with applied SP2 . The SSIS component you are trying to install is RTM(Release to Market)Version.So there is version mismatching. I guess you need to uninstall SQL Server or Downgrade (if it is possible). |
 |
|
|
zeeshan13
Constraint Violating Yak Guru
347 Posts |
Posted - 2008-12-23 : 18:53:41
|
| Although it prompted for an erorr; I clicked next and SSIS was installed sucessfully. Using the SQL job I than schedule and run the automated job sucessfully which generated the flat file scucessfully (I was unable to run the package outside BD Studio before installing SSIS).Hoepfully tomorrow I am going to the same thing on my client server.Thanks & Happy holidays.Thank you all for your help. |
|
|
|
|
|
|
Unable to install SSIS.