WinSCP.SessionRemoteException: Error listing directory in SQLCLR but works in SSIS script task

Advertisement

planet20
Joined:
Posts:
2

WinSCP.SessionRemoteException: Error listing directory in SQLCLR but works in 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.
Thanks
Description: Attached the log file

Reply with quote

Advertisement

martin
Site Admin
martin avatar
Joined:
Posts:
40,567
Location:
Prague, Czechia

Re: WinSCP.SessionRemoteException: Error listing directory in SQLCLR but works in SSIS script task

Please attach also a log for the successful download from the SSIS script task.

Reply with quote

planet20
Joined:
Posts:
2

File attached for successful download using Script task

Hi Martin, Please find attached log file for the successful download using script task
Description: Successful log

Reply with quote

Guest

Reoslved

Hi Martin,
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.

Reply with quote

Advertisement

You can post new topics in this forum