Forum » Support and Bug Reports »

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.

Options
Add an Attachment

If you do not want to add an Attachment to your Post, please leave the Fields blank.

(maximum 10 MB; please compress large files; only common media, archive, text and programming file formats are allowed)

Options

Topic review

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.
planet20

File attached for successful download using Script task

Hi Martin, Please find attached log file for the successful download using script task
martin

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.
planet20

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

Documentation

Support

Associations

Follow Us