question on data transfer!!

Last Post 03 Oct 2008 11:14 AM by sqlserverdeveloper. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
sqlserverdeveloper
New Member
New Member

--
03 Oct 2008 08:57 AM
Issue with our FTP job(SQL2000 server):
We are executing FTP.bat file from the sql job as OS command in SQL2000, almost every other day
we are seeing in the FTP output file as "connection closed by remote host", due to
which the files are not getting FTP'ed from mas90 box(unix box) to SQL server.
We are trying to see what might cause this to happen.

The below are the contents of the FTP output file:
C:\dir1\dir2 ftp -s:C:\commands.txt IPaddress
Connected to IPaddess
Connection closed by remote host

Per the above output file: we see connected to IP and then conn closed!!!
Our networking team is saying that communication between mas90 box and sql server exists, they do'nt see any other problem.
I am trying to find out if there are any other functions SQL is going at the time it attempts to connect for FTP. I checked the event log in the sql server, but can't find anything regarding that connection lost.
I do'nt know where to look at to find what's causing closing the connection.
In case if we have to check the mas90 unix box, what should we check for??
Please advice, as I really do'nt know what to do at this time.
Thanks!!


sqlserverdeveloper
New Member
New Member

--
03 Oct 2008 11:14 AM
Actually the batch file runs fine one day and the other day we get the connection closed by remote host.
I am not sure what you mean by how you login to unix, below are the FTP.bat file contents:

c:
cd \folder1\folder2
ftp -S:C:\folder1\folder2\commands.txt IPaddess

Thanks!

sqlserverdeveloper
New Member
New Member

--
03 Oct 2008 01:53 PM
quote:

Originally posted by: rm
You have to specify unix id in ftp to make connection, and ensure ftp server is up running.


Actually per FTP output file, it shows it's getting connected, but immediately after that "connection closed by remote host" is happening. Please see below contents of the FTP output file

C:\dir1\dir2 ftp -s:C:\commands.txt IPaddress
Connected to IPaddess
Connection closed by remote host

Thanks!
You are not authorized to post a reply.

Acceptable Use Policy