Running SSIS on a clustered server with SQL Server 2005

Tags:
Clustered servers
SQL Server 2005
SQL Server Integration Services
We are using SQL Server 2005, 64-bit, on a Windows 2003 clustered server with Active/Passive 'A' and 'B' nodes. Databases are on a shared LUN. I can run all my SQL Server Integration Services packages on the 'A' node with no problem. When we fail over to the 'B' node, though, packages are failing. I know that SSIS is not cluster service. My question is, how can I run SSIS packages on the second node?

Answer Wiki

Thanks. We'll let you know when a new response is added.

SSIS cannot be installed as a cluster-aware service, but it can be made cluster-aware after the initial install.

If you want to use SSIS ‘out of the box’, then you will need to explicitly install SSIS on all nodes of your cluster. When you apply maintenance or add SSIS packages, you will need to do this on each SSSIS node separately. In this situation, SSIS is not cluster-aware and will not fail-over with the rest of the cluster.

If you want to make a SSIS cluster, this link from Microsoft discusses how to do this: http://msdn.microsoft.com/en-us/library/ms345193.aspx

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following