When a DNS name exists which resolves to 2 IP addresses, how can this be used as the server name in the SQL Server source? One of the two IP addresses is always active due to Failover Clustering, but if DNS is roundrobin, there is no way to determine which IP address is the "live" one. Is there an internal setting in the source to allow for this?
