Re: Trouble shooting SQL 2000 cannot open file ftp file
Yes.
- martin
Post a reply
Before posting, please read how to report bug or request support effectively.
Bug reports without an attached log file are usually useless.
Topic review
- Guest
Re: Trouble shooting SQL 2000 cannot open file ftp file
Hi Prikryl,
Are you referring to
Thank you,
Michael
Are you referring to
"c:\program files\winscp\winscp.com" /script=c:\batch\FTPOAPToKTTransfer.ftp
Thank you,
Michael
- martin
Re: Trouble shooting SQL 2000 cannot open file ftp file
It seems that you execute WinSCP with
C:\Windows\system32 as startup directory. As you do not specify path to the FTPOAPToKTTransfer.ftp script file, WinSCP looks for it in that directory. Is it there? If not, make sure you specify full path or start WinSCP from directory where the script is actually located.
- mrosales
Trouble shooting SQL 2000 cannot open file ftp file
Hello,
I am receiving the following error message
We have a MS SQL 2000 job that is calling to the batch. The batch then runs the ftp file. The job is failing at step one.
We have the following environment
1. WinSCP ver 4.2.3 build 494
2. MS SQL 2000
3. Windows Server 2003 r2 sp2
4. Using SFTP
5. Using scripting/automation
6. Connecting to GlobalScape's EFT server
7. The command in the batch is
8. The commands with in the
Solution we tried
1. gave everyone full rights to the folder that contains the batch files
2. gave everyone full rights to the folder for WinSCP
What currently works is
Microsoft
The client is requesting to use SFTP to submit data.
Thank you for any assistance,
mrosales490@gmail.com
I am receiving the following error message
Executed as user: NACCRRA\sqlservers. C:\Windows\system32> "c\program files\winscp\winscp.com" /script=FTPOAPToKTTransfer.ftpCannot open file FTPOAPToKTTransfer.ftp. Process Exit Code 1. The step failed
We have a MS SQL 2000 job that is calling to the batch. The batch then runs the ftp file. The job is failing at step one.
We have the following environment
1. WinSCP ver 4.2.3 build 494
2. MS SQL 2000
3. Windows Server 2003 r2 sp2
4. Using SFTP
5. Using scripting/automation
6. Connecting to GlobalScape's EFT server
7. The command in the batch is
"c:\program files\winscp\winscp.com" /script=FTPOAPToKTTransfer.ftp
8. The commands with in the
ftp file are
option confirm off
open Controltec
cd OAP
cd ApplicationExport
cd Staging
lcd D:\ImportExport\OAP
option transfer binary
get * -delete *
close
exit
Solution we tried
1. gave everyone full rights to the folder that contains the batch files
2. gave everyone full rights to the folder for WinSCP
What currently works is
Microsoft
ftp client on the server. MS SQL 2000's job call to the batch and the batch runs the ftp commands using Microsoft's ftp client.
The client is requesting to use SFTP to submit data.
Thank you for any assistance,
mrosales490@gmail.com