Anyone here use DTS and VB6?

What are the advantages?

I tried executing a DTS package I have installed locally on a SQL Server
from my workstation that included an FTP. It would appear the DTS package
runs within my workstation instead of executing on the server. I'm not sure
if this is an advantage or not -- but it ran dog slow and the FTP ended up
not working due to C:\TEMP not existing on my machine.

Opinions?

Not sure what the question is here.

DTS is a client application (just like VB) so of course it runs on the client.
If you installed a VB app on your machine you wouldn't expect it to run on a
server would you?

For FTP I tend to do it from t-sql (running on the server).
http://www.nigelrivett.net/s_ftp_PutFile.html
http://www.nigelrivett.net/s_ftp_GetDir.html

"DavidM" wrote: