SSIS with HA

• cmc123

  Right there with Babe

  Points: 732

  More actions

  August 3, 2015 at 1:01 pm

  #300918

  Hi,

  I got a requirement to build SSIS with HA b/w two datacenters.

  Comple requirement is , When there is a failover happens SSIS Pakages should work from other server which is at different datacenter .

  Here,

  SQL Server 2012.

  I proposed with SQL Always-on but not sure how can build the logic when there is a real failover happens.

  Also, I am looking at SQL Mirroring for SSISDB but wanted understand how can i build the logic at SQLJObs.

  I tested in my local PC with mirroring but looking for build the script which can handle the pakage run at mirror server.

  Thanks you all guys.