EXECUTE PROCESS TASK - FTP Files via .CMD File 1

[eb24]

I have some DTS packages that manipulate data and export 3 files into a drive. I am trying to use EXECUTE PROCESS TASK at the SUCESSFULL completion of these packages to FTP these files, but the Move_MyFiles.cmd hangs after the FTP line in the following file:

cd w:
ftp 
open ThisFTPSite ThisPort
user MyUserName MyPassWord
bin
put File1
put File2
put File3
bye

This works fine via the CMD prompt, thus I thought it would work by simply copying it to a .CMD file but no luck. If I run this via a CMD prompt, i.e. Move_MyFiles.cmd, it hangs at ftp> without running the next line: open ThisFTPSite ThisPort.

I am assuming I need to run the FTP command with the OPEN and USERNAME and PASSWORD together but don't know how.

Any assistance will be greatly appreciated.

 

[yksvaan]

Search the forum, I think I've seen these cases before.

Cheers


[blue]Backup system is as good as the latest recovery[/blue]

 

[EdwinGene]

The 'open' command, username, and password need to be in a Commands file separate file from the .bat file with the FTP command. Then just call the .bat file.



FTP.bat file:

W:
ftp -s:ftp.cmd



ftp.cmd file:

open ThisFTPSite
MyUsername
MyPassword
bin
put File1
put File2
put File3
bye