I have people here suggesting that DTS packages should be run on a separate
server from SQL Server. Their concern is security and a little performance.
The DTS script in question is designed to run a VB script to read data from
several other servers and use this data to populate SQL Server tables. We
try to limit access to our SQL Server machines to a small number of
application servers. Running this DTS script would allow connections to
several departmental servers over which we have no control.

So we thought about putting the DTS package on an intermediate server. It
would connect to the remote servers, transform the data and populate the SQL
Server tables. Is this a good idea? Will the network traffic between the
DTS server and SQL Server be a problem? Has anyone else set up an
environment like this.

Thanks for your response.