Post reply

Clustering SSIS , this SSIS the question !!!

  • June 5, 2009 at 9:31 am

    #138375

    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

    #1005394

    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