I need to create a package with "Transfer SQL Server Objects Task". the source is a external server with AlwaysOn multi subnet. Is there a way I can specify the AlwaysOn listener name on the SMOServer connection with "MultiSubnetFailover=TRUE"?
Hello KenJ, Thank You for your reply, Using the listener name will work for same subnet AlwayOn set up. This is a multi-subnet where the listener have two IPs associated with it, and its publishing both the IPs in a round-robin manner. I do not have access to those clusters to configure HostRecordTTL and RegisterAllProvidersIP settings. Having "MultiSubnetFailover=TRUE" will stop timing out the client connections in this scenario as it will try to connect both the IPs at once and proceed with the active IP. Anyway .NET 4.6.1 onward has this feature inbuilt, not sure that will help me or not. still there may be some issues like this
https://blogs.msdn.microsoft.com/dataaccesstechnologies/2016/05/07/connection-timeout-issue-with-net-framework-4-6-1-transparentnetworkipresolution/ Currently, the packages are set to use only the primary server, I'm busy with some other projects and will have a look at them later ;) ,