Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I'm running SQL Server 2005 enterprise edition on a 2 node active-active cluster windows 2003 server. I go to add/remove programs, click on SQL Server and then the link for "to install a new component, click here". It then says enter the location. Where do I go to find SSIS add-on from here?

Is SQL Server Integration Services offered on the SQL Server Installation dvd or is this something I need to download?

thanks in advance

share|improve this question

2 Answers 2

up vote 3 down vote accepted

SSIS is on the SQL 2005 installation disk. To install it, just pop the disk in and start the installation wizard. You can then install SSIS as a package, and just make sure you don't tick any of the database engines, or else you'll get another SQL instance installed!

share|improve this answer
    
Do I need to do anything special because it is being installed on a cluster server? I'm assuming I should stop all sql server services before installing the SSIS add-on? –  phill Jun 15 '09 at 22:07
    
Honestly, I've no idea, because I'm not the DBA for our clustered servers, only our stand-alones! –  Mark Henderson Jun 16 '09 at 1:53

Regarding the cluster...

This article might be helpful: http://msdn.microsoft.com/en-us/library/ms345193.aspx

There are some special notes (problems) in there about trying to cluster integration services in an a/a cluster. Integration services will not run more than one instance on a machine, so when it fails over an tries to start up, it will fail, potentially affecting the group.

Microsoft does not recommend that the Integration Services service be configured as a cluster resource.

"The Integration Services service supports the administrative interface in SQL Server Management Studio for listing, starting, stopping, monitoring, importing, and exporting Integration Services packages. The Integration Services service is not required to design packages. The Integration Services service is also not required to run packages, or to schedule SQL Server Agent jobs that run packages."

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.