Hi,
We are in the process of replacing an existing SQL server with a new
clustered SQL Server in Active/Passive configuration. The old server
houses many DTS packages that pulled data from various data sources.
Some of those data sources required ports be opened on firewalls, so
that the old SQL server could access and pull the data. Over the years,
there have been a large number of DTS packages and Firewalls ports
holes created,

For our new cluster, we were planning on giving the virtual cluster the
name and IP of the old server so that applications that access the
cluster by name would work unchanged. Our hope was that by using the IP
address of the old server as the virtual cluster IP, we would not have
to modify the firewall settings as well.

The concern that I have is after we migrate the DTS packages from the
old server to the new cluster. When the DTS packages run, will the DTS
package attempt to initiate the connection using the virtual cluster
IP, or the IP of the cluster node? If it is the latter, then we would
have to have all the firewalls modified to allow traffic to each
cluster node.

Is there a way to have the DTS packages use the virtual cluster IP when
establishing a connection to a remote data source.

Thanks in Advance!!