FTP

[Bell1991]

I am curious if this is possible. A client of ours is going to set up a FTP site and update the data once a month. I will need to write a FTP DTS that will get the data read it into a temp database and then query that data and update a database. Is this possible?

Thanks,
-Bell

 

[nigelrivett]

Sure .
I wouldn't do it using dsts though.
Here are SPs that do an FTP put and getdir. GETFile and other things are similar. The advantage is that it uses a batch file and the command line FTP so you can test everything manually.
Just create an SP to ftp the file, use bulk insert to insert the data, create a global remp table, then query it.
Schedule the SP in a job step and you are done. Should take a few minutes to set up.

http://www.nigelrivett.net/s_ftp_PutFile.html

http://www.nigelrivett.net/s_ftp_GetDir.html

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.