asked on

DTS to ftp files from server to local computer using CuteFTP

Hi Experts,

I've been asked to develop a DTS which will pull files from an ftp server and place them on a local computer using CuteFTP.
I'll then need to check for and log errors to a txt file which will be sent by email.

I'm new to DTS and unsure how to get the FTP side of this to work. Any idea?

Cheers,
Sarah

SOLUTION

obahat

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

sarahth

ASKER

Someone suggested I use a Dynamic Properties task to set variables which would then be used by a VB script which would invoke the FTP procedure; connecting to the site, downloading the files and then logging errors if they occur.

Can this be done?

nmcdermaid

Does CuteFTP work with the command line?

Then you could use an Executre Process task to run it.

Failing that I know the standard windows FTP works with the command line. Also there is an actual FTP task in DTS that you can use.

If you wanted to just copy several files you could use ActiveX or Execute SQL tasks in DTS.

sarahth

ASKER

I'll be using CuteFTP Pro which can be run from the command line and is scriptable. Unfortunetly I have to use this program because the process will involve the exchange of digitial certificates.

Do you know of any web sites or have any example scripts that will execute the ftp program and retrieve the files?

Thanks
Sarah

ASKER CERTIFIED SOLUTION

nmcdermaid

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

nmcdermaid

This may also help

http://help.globalscape.com/help/cuteftpserver2/Creating_a_custom_command.htm

sarahth

ASKER

Thanks for all the suggestions - the sites recommended were quite helpful so I think I'll be able to work this one out :)

I found this whilst searching for scripts

http://www.globalscape.com/files/PR6TE_usersGuide.pdf

Makes interesting reading.

I'll split the points between nmcdermaid and obahat. Thanks for your help guys.

Sarah

sarahth

ASKER

Sorry, I think I just awarded to nmcdermaid - I'll get these split asap