Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlserverdeveloper
Posting Yak Master
243 Posts |
 Posted - 2008-04-02 : 12:37:08
|
| We are having the Connection closed by remote host issue when we are trying to run the below code in a ftp.bat file as a sql job:c:cd \server\dirftp -s:C:\folder1\FtpCommands.txt IPaddresswe wanted to debug the issue, then added the debug command which is shown below, then the error was "Unknown host debug".c:cd \server\dirftp debugftp -s:C:\folder1\FtpCommands.txt IPaddressPlease let me know how I can add the debug and trace commands to the ftp.bat file as I am running this .bat fileas a OS command type within the SQL job. I greatly appreciate your help!! |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
sqlserverdeveloper
Posting Yak Master
243 Posts |
Posted - 2008-04-03 : 10:29:58
|
| 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:Usernamepasswdcd /folder1/folder2/folder3binpromptdebugtraceget file1.soamget file1.soa.00?get file2.soamget file2.soa.00?get file3.soamget file3.soa.00?get file4.soamget file4.soa.00?quit |
 |
|
|
|
|
|
FTP SQL error