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.