Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
TAS
Yak Posting Veteran
65 Posts |
 Posted - 2005-09-14 : 16:19:34
|
| Is there any way to read/delete file from ftp server by using DTS package? I tried FSO in ActiveX Script Task, but it seems there's no way to open a file on ftp server.If DTS package has no way to work, what's the other option? I use Access as front end. By clicking the button, it downloads all text files from web server to a local folder, then ranames them, reads them and deletes them if files are blank. After this, old text files on ftp server should be deleted and the new blank text files should be created. Now, I have a DTS package to download, rename, read and delete, but I'm not able to figure out how to delete/create files on ftp server. |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-09-18 : 22:52:21
|
| refer to Nigel's site: http://www.mindsdoor.net/#FTPHTH--------------------keeping it simple... |
 |
|
|
|
|
|
Read/Delete File from ftp server