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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Modify folder on ftp site through DTS?

Author  Topic 

p.shaw3@ukonline.co.uk
Posting Yak Master

103 Posts

Posted - 2005-11-08 : 11:05:54
Does anyone know of a way I can rename a folder that resides on an FTP site. I need to know if there is a way to log-in to the FTP server from within the ActiveX script and then rename a specific folder. Can this be done?

Thanks, Pat.

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2005-11-08 : 11:33:07
I don't think that renaming a remote directory is a supported FTP function.

You can rename remote files, but I have never seen a remote directory rename.



CODO ERGO SUM
Go to Top of Page

p.shaw3@ukonline.co.uk
Posting Yak Master

103 Posts

Posted - 2005-11-08 : 12:55:02
But how could I at least access the FTP site from a script, providing username and password?
Go to Top of Page

p.shaw3@ukonline.co.uk
Posting Yak Master

103 Posts

Posted - 2005-11-08 : 16:00:16
Actually, I could get round the problem by renaming the files as you said this was possible. Could you give me more information on this please?
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-11-09 : 00:57:21
>>But how could I at least access the FTP site from a script, providing username and password?

See if this helps you
http://www.mindsdoor.net/FTP/s_ftp_GetDir.html

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

jhocutt
Constraint Violating Yak Guru

385 Posts

Posted - 2005-11-09 : 15:24:32
Yes you can rename a dir using ftp if the user has permission to do so.

rename xxx yyy


"God does not play dice" -- Albert Einstein
"Not only does God play dice, but he sometimes throws them where they cannot be seen."
-- Stephen Hawking
Go to Top of Page
   

- Advertisement -