sql server dts: DTS and VB -- sql server dts

DTS and VB

DavidM
12/18/2004 5:58:03 PM

sql server dts:

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?

RE: DTS and VB

Nigel Rivett
12/18/2004 7:47:04 PM

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

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.