WinSCP .NET assembly throwing "The winscp.exe executable was not found at location of the assembly" when installed to GAC for SSIS

Question

I have a package which downloads files from FTP using WinSCP which runs perfectly when I execute it locally. But we are facing issues when we run from the deployed version from SSIS DB Catalog. GAC registration already done for the .dll file.

Below is the error that we are getting.

enter image description here

UPDATE

enter image description here

score 5 · Accepted Answer · edited Jun 20 '20 at 09:12

Quoting documentation on Installing the WinSCP .NET assembly:

Installing

The package includes the assembly itself (winscpnet.dll) and a required dependency, WinSCP executable winscp.exe.

The binaries interact with each other and must be kept in the same folder for the assembly to work. In rare situations this is not possible (e.g. when installing the assembly to GAC), make use of the Session.ExecutablePath property to force the assembly to look for the winscp.exe in a different location.

WinSCP .NET assembly throwing "The winscp.exe executable was not found at location of the assembly" when installed to GAC for SSIS

1 Answers1