Instead of Creating a standard DW Connection, use Dynamic Connections.
the Dynamic Connection tool allows you to create one connection, and specify the local information and the remote information and it will connect to the correct server based on the address.