I have resolved the issue by using the IP address instead of the hostname to the remote server.
Thank you for taking the time to reply, appreciate your help.
Hi Martin, Please find attached log file for the successful download using script task
Please attach also a log for the successful download from the SSIS script task.
I am trying to download files from a remote machine. I have SQLCLR assembly built with the GetFiles as a SP. When I call the SP i get the below error
Error: WinSCP.SessionRemoteException: Error listing directory '/dev/edx/input'.
General failure (server should provide error description).
Error code: 4
Error message from server (en): The requested operation failed.
When I write the winscp c# code in script task it downloads files. Can someone please help me on why its not working using the SQLCLR?
Please let me know if further detailsa re required. I have attached the log file as well.