Automate changing SSIS connection at runtime
October 15th, 2021 in Blog, Integration Services, SQL Server, SSIS, UncategorizedRecently a customer came to us with an issue: “We have a primary/secondary AlwaysOn failover cluster, we want the data warehouse ETL to always pull from the secondary read-only replica. When the primary fails over, how can we detect this and repoint the ETL to the new secondary?” This led us to the following qualification steps:1. Is the secondary server accessible? a. Yes – Use it. b. No – Try the primary server.2. Is…
» Read more