FTP in Batch File not working with Windows Task Scheduler

Where do I put that? I know little about Batch files someone helped me with this code.

Also I noticed that when I go to the Batch file and I right on the Batch file I notice the cmd.exe window pops up and inside the black window the word "Password:_" comes up. The cursor is not blinking. I also try to type in a password that I believe to be relevant and nothing happens. No characters move the cursor or show asterisk. Any thoughts as to why that is happening?

Try following batch script if this works for you!

@ECHO OFF
(	ECHO OPEN ??.??.??.??
	ECHO UserName
	ECHO Password
	ECHO CD /Backup_DataFolder
	ECHO BINARY
	ECHO SEND "C:\Users\Public\ServerDataBackup\SRSCDataBackup.7z"
	ECHO QUIT)>Config.ftp
 
FTP -s:Config.ftp

                                              

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:

I tried that and no difference? The file is about 40 mb that I am trying to upload. Do you have any other ideas? What about my commands in the Task Scheduler are they correct?

Try to execute the script from command line? If this uploads the data then their must be something wrong with scheduled tasks job properties.
Make sure "Run" points to the script file (including path) and "Start in" points to the folder where the the script resides.
Like shown in attached picture:

Still not working. Farhankazi You can see from the question that the last line for me is
Echo QUIT
ftp -n -s -i

You have this:
ECHO QUIT)>Config.ftp
FTP -s:Config.ftp

I don't have what you have. Can you clarify the config.ftp with an example.

When I click Run on the task it shows that it runs with no errors within a few seconds. The actuall upload manually takes at least 3 minutes not 3 seconds. Wwhen I go to the FTP to verify the file is not there. Do you see any problems with my code?

I tried the ECHO CD Backup_DataFolder/  change.
I ran the Task and it ran very quickly. It should take at least 3-4 minutes. Here is the screen shot. let me know if you need more.
Also could a space between the characters in the folder "Batch Folder\" make a difference?

Action: Start a Program
Program/Script: ftp
Add Arguments: -n -s:"C:\Users\Batch Folder\Documents\BATCH-FTP_SCATDB_DATA.bat"

Just wondered as I actually used my folder containing my user name which has a space between?

here are the results.

You should not use a CMD/batch script as input for FTP. That does not make any sense. The batch file itself calls the FTP command. The task is hence

I made exactly those changes.
I am not getting any results from the batch file. I can with Filezilla manually.
for the cmd.exe do I need to full path in that as well?
Also does that mean I do not use the "  -s " anywhere in anything?
We are trying to do a nightly backup rewriting over the database from the night before.

Here is the latest result set. It looks like it is starting but nothing is getting uploaded. I am baffled? Any thoughts?

When you view your Scheduled Tasks, use the Explorer to do so, and go into the last menu of Explorer. There is a menu item for the log file. Have a look at that - it should reveal more details.
The log file is written circular, that is you have to search for a ====== line, which marks the "end of file" position.

You might need to add the complete path for cmd.exe (%Systemroot%\system32\cmd.exe), but as far as I can remember that path is added automatically as soon as you save the task.

For testing, you should allow the task to act interactively (that is, it should run with your account while you are logged in). And you should add a
pause
at the very end of the batch file (after ftp call).

About -s: Yes, the way the FTP commands are provided you do not need any -s.

I am to the point where I may need to take this offline and hire someone to get this to work. I can pay  if someone can troubleshoot this. I have tried everything you have asked to the best of my knowledge.

I do not know how to add a pause in the Batch file. Something is just not working and you have all the code I am using. The Task stays hung in the Running position and nothing happens. Unless you think that the pause will do the trick after the FTP call (which I do not even know where that is). I have everything in this thread in place. I did put in the full file path on cmd.exe. I also there is no ====== line anywhere to be found.

The only thing I did not get an answer on was whether the space between my name in the folder \Rob Burdine\ would make a difference in the Action section. I changed it to a new folder with no space but there was not a difference. I have tried so many things and I have. I have all but given up. Please advise me of my options I am just about out of them.

A ha I think I am on to something. Finally can you help me with this. Before I was getting the prompt below when I simply clicked on the batch file and get the cmd.exe with the word password in it and a non-blinking cursor.

I typed in my user password and the black screen went away and dissapeared. The file got  uploaded to the FTP site but it had a file size of Zero. So what does that mean? That I have to put some kind of extra code that puts in my user login password for Windows 2008 Server in that little command window you see below.

FTP creates a file of zero size on copy (get or put) if the source does not exist.

About the passowrd, you can try to combine user and password on one line - depending on the remote FTP server, this works.

@echo off
(echo open ??.??.??.??
 echo user MyUser MyPassword
 echo cd /Backup_DataFolder
 echo bin
 echo put "C:\Users\Public\ServerDataBackup\SRSCDataBackup.7z"
 echo quit
) | ftp -n -s -i

                                              

1:
2:
3:
4:
5:
6:
7:
8:

Minor correction... Remove -s switch from FTP statement.

@echo off
(echo open ??.??.??.??
 echo user MyUser MyPassword
 echo cd /Backup_DataFolder
 echo bin
 echo put "C:\Users\Public\ServerDataBackup\SRSCDataBackup.7z"
 echo quit
) | FTP -n -i

                                              

1:
2:
3:
4:
5:
6:
7:
8:

Of course. Cut&Waste error ;-)

Okay once again I am confused.
DO I use "echo Bin" or "echo Binary"


Earlier you told me to switch to "echo cd Backup_SunRiver/
Now it is back to "echo cd /Backup_SunRiver
Which is it ?

echo user MyUser
echo MyPassword

Now its "echo user myuser mypassword "..................you want that right together correct ? Just a space between them. Right?

I hate to say it but it did not work. I am posting the response to this problem that the Hosting provider said may be the problem. I do not know  if that is true or not but I thought I would put it past you guys.
The site I am uploading to is a Linux box. However I can upload with Filezilla with no problem. They say:
 
Hello Rob,  
  The issue is that batch files are a Windows convention, and while it is possible to run them on a Linux machine, all of the commands used in the .bat file must be Linux commands.
 
@echo off  
(echo open ??.??.??.??  
echo user MyUser MyPassword  
echo cd /Backup_SunRiver  
echo bin  
echo put "C:\Users\Public\ServerDataBackup\SRSCDataBackup.7z"  
echo quit  
) | ftp -n -s -i  
 
In the above script, only cd, quit, and ftp are valid commands in RedHad Linux. You may want to consider using a bash script instead. Below are some resources on bash scripting:  
 
http://en.wikipedia.org/wiki/Bash  
http://www.linuxconfig.org/Bash_scripting_Tutorial  
http://tldp.org/LDP/abs/html/  

I called them back got a different technician and he said that the guy who gave me this answer was wrong. What do you think? Remember I am sending this up from a Windows 2008 Server's Task Scheduler to at box that does happen to be a Linux box but I do not see how that would make a difference just to transfer the zipped file up via FTP? This thing just gets more interesting by the day........? !

"Wrong". The commands are executed on Windows, producing an output stuffed into FTP. The text stuffed into FTP needs to be FTP convention. The only questionable FTP command is USER, all others are FTP standard.

The Hosting provider acknowledged that they were mistaken. However they checked the code and said this:

This is a 'local' issue for you and you would need to continue troubleshooting it as such.  We have verified that the FTP server on our end is configured correctly and is working as expected.  While your code may be valid, since this is on your server in an environment we are not familiar with there is little else we can do to assist in this regard.

Should I post my question to the Windows 2003 Server zone as there seems to not be a zone for Windows 2008 Server? I have exhausted what I know to do..

Unless there is something I could check on the Server that would stop the process from launching when clearly I can do the upload manually with Filezilla? Help Me Obi One your my only hope !

I love it ! My friend after having 23 posts you should have realized I haven't the slightest touch of knowledge here. HA HA HA! Don't get me wrong I am eternally grateful for the help.

Here is what I did I got as far as the user name password before I hit the road bump.
I got this response after the user password. The user and password seemed to have worked. I did get the message then it seems to have gone past that and got hung up on the
"echo cd /Backup_SunRiver"

331 Please specify the password.
230 Login successful.
ftp> echo cd /Backup_SunRiver
Invalid command.
ftp> echo cd /Backup_SunRiver
Invalid command.
ftp> echo cd /BackupSunRiver
Invalid command.
ftp>

I took out the " _ " underscore thinking it might be that. So far that is as far as I got. Any thoughts?

Dude you must be a saint to have to deal with me. Here is what I got after I  put in the following line:
put "C:\Users\Public\ServerDataBackup\SRSCDataBackup.7z"

200 PORT command successful. Consider using PASV.
425 Failed to establish connection.
ftp>

Is this the culprit? I do not know what PASV means?

I looked up the PASV problem. One said it may be the Firewall. So I turned it off to make sure and that did not do it.
Another said to try typing Passive or PASV after the ftp> so ftp> passive or ftp> PASV and I got back an invalid command? I think we are getting close here must be something simple?

Did you just type PASV, nothing else on that line?

Yes that is what the tech responses out on Google said to do? I also tried the word passive.

The line was ftp> PASV and I also tried ftp> Passive any thoughts?