June 5, 2009 at 9:31 am
I am pretty much confused as to what to do; According to MS http://msdn.microsoft.com/en-us/library/ms345193.aspx, the disadvantages in making SSIS cluster aware seem to be greater than the advantages; all I want to do is to be able to run my DTS packages every time the cluster fails over to the inactive node; what is the best and safest approach?
This is my current environment:
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 equallogic iscsi SAN.
Any help would be greatly appreciated
June 5, 2009 at 9:48 am
Check this out: http://msdn.microsoft.com/en-us/library/ms345184.aspx
This may seem unrelated at 1st, but give it some thought from an architectural perspective.
If you have an SSIS parent server containing parent packages.
Then several Child SSIS Servers for both load balancing and possibly failover.
The architecture would also call for a seperate database server.
Each child SSIS server can contain every package. This way if a failure is reported back to the parent server it can try to run the same package on a different server.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply