- Posts: 12
- Thank you received: 0
Automating SFTP transfers
12 years 7 months ago #1476
by Rob
Automating SFTP transfers was created by Rob
We are using Enterprise version 4.2.4.0
We are trying to use the SFTP for file transfer.
Bellow is the error log.
Information 1/31/2011 3:55:56 PM Preparing to execute: SFTP TEST
Information 1/31/2011 3:55:56 PM Package Started
Information 1/31/2011 3:55:56 PM Executing Ftp (Download): download
Information 1/31/2011 3:55:56 PM SSH File Transfer Protocol
Information 1/31/2011 3:55:56 PM Connecting to: xxxxx
Information 1/31/2011 3:55:57 PM Getting List of files
Information 1/31/2011 3:55:57 PM Mask: *.txt
Information 1/31/2011 3:55:57 PM Done!
Information 1/31/2011 3:55:57 PM Found: 8 File(s)
Information 1/31/2011 3:55:57 PM Files : Item_Match.txt
Information 1/31/2011 3:55:57 PM Downloading Item_Match.txt
Error 1/31/2011 3:55:57 PM Error happened during downloading Item_Match.txt File SFTP server error occurred: Folder not found: m:\root\test\Item_Match.txt
Information 1/31/2011 3:55:57 PM Finished Execution Ftp: download
Error 1/31/2011 3:55:57 PM Package Failed
We are trying to use the SFTP for file transfer.
Bellow is the error log.
Information 1/31/2011 3:55:56 PM Preparing to execute: SFTP TEST
Information 1/31/2011 3:55:56 PM Package Started
Information 1/31/2011 3:55:56 PM Executing Ftp (Download): download
Information 1/31/2011 3:55:56 PM SSH File Transfer Protocol
Information 1/31/2011 3:55:56 PM Connecting to: xxxxx
Information 1/31/2011 3:55:57 PM Getting List of files
Information 1/31/2011 3:55:57 PM Mask: *.txt
Information 1/31/2011 3:55:57 PM Done!
Information 1/31/2011 3:55:57 PM Found: 8 File(s)
Information 1/31/2011 3:55:57 PM Files : Item_Match.txt
Information 1/31/2011 3:55:57 PM Downloading Item_Match.txt
Error 1/31/2011 3:55:57 PM Error happened during downloading Item_Match.txt File SFTP server error occurred: Folder not found: m:\root\test\Item_Match.txt
Information 1/31/2011 3:55:57 PM Finished Execution Ftp: download
Error 1/31/2011 3:55:57 PM Package Failed
Please Log in or Create an account to join the conversation.
12 years 7 months ago #1491
by admin
Mike
ETL Architect
Replied by admin on topic Re: Automating SFTP transfers
Can we get the SFTP server software from somewhere to perform our own tests?
Or can we connect to yours?
Mike
Or can we connect to yours?
Mike
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
12 years 7 months ago #1492
by Rob
Replied by Rob on topic Re: Automating SFTP transfers
I do not have the ability to let you connect to this site.
It’s WS_FTP Server.
Rob
It’s WS_FTP Server.
Rob
Please Log in or Create an account to join the conversation.
12 years 7 months ago #1493
by admin
Mike
ETL Architect
Replied by admin on topic Re: Automating SFTP transfers
Robert.
I have downloaded and installed WS_FTP Server 7.5 (evaluation)
However I am not able to connect to it with filezilla.
Can you email us some screen shots with the settings so it will be exactly as yours
Mike
I have downloaded and installed WS_FTP Server 7.5 (evaluation)
However I am not able to connect to it with filezilla.
Can you email us some screen shots with the settings so it will be exactly as yours
Mike
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
12 years 7 months ago #1495
by Rob
Replied by Rob on topic Re: Automating SFTP transfers
do a quick connect to hostname with the user and password, over port 22.
Please Log in or Create an account to join the conversation.
12 years 7 months ago #1498
by admin
Mike
ETL Architect
Replied by admin on topic Re: Automating SFTP transfers
I have done it already with filezila
Extract from log file
SSH Server Listening on 0.0.0.0 port 22
Failed to start SSH Transport: No host keys
There are some host keys
I have tried default ones and tried my owns nothing is working
Mike
Extract from log file
SSH Server Listening on 0.0.0.0 port 22
Failed to start SSH Transport: No host keys
There are some host keys
I have tried default ones and tried my owns nothing is working
Mike
Mike
ETL Architect
Please Log in or Create an account to join the conversation.