April 2, 2008 at 10:35 am
We are having the Connection closed by remote host issue when we are trying to run the below code in a http://ftp.bat file as a sql job:
c:
cd \server\dir
ftp -s:C:\folder1\FtpCommands.txt IPaddress
we wanted to debug the issue, then added the debug command which is shown below, then the error was "Unknown host debug".
c:
cd \server\dir
ftp debug
ftp -s:C:\folder1\FtpCommands.txt IPaddress
Please let me know how I can add the debug and trace commands to the http://ftp.bat file as I am running this .bat file as a OS command type within the SQL job. I greatly appreciate your help!!
April 2, 2008 at 11:33 am
April 3, 2008 at 9:36 am
I need to find out if debug and trace will help us to determine why the connection is being lost as we are losing connection once in a while when we are FTP'ing lot of soa file's from Unix box to SQL server within a SQL job, below is the code I am planning to use to resolve the conn lost issue:
Username
passwd
cd /folder1/folder2/folder3
bin
prompt
debug
trace
get file1.soa
mget file1.soa.00?
get file2.soa
mget file2.soa.00?
get file3.soa
mget file3.soa.00?
get file4.soa
mget file4.soa.00?
quit
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply