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.