Problems with SSIS and WinSCP Assembly 5.21.5 :: Support Forum

mkfromhighlands
Joined:: 2022-11-24
Posts:: 1
Location:: Luxembourg

Problems with SSIS and WinSCP Assembly 5.21.5

2022-11-24 10:52

Hi there,

I use WinSCP Assembly in my SSIS Script task. As soon as my package runs into the Session.Open part, I get the following error message from debugger:

Information: 0x1 at Upload to FTP, Error: ERROR: WinSCP WinSCP.SessionLocalException: WinSCP process terminated with exit code -1073741819 (C0000005).
There was no output.
Response log file C:\Users\...\AppData\Local\Temp\wscp3164.029341EE.tmp was not created.
This could indicate lack of write permissions to the log folder or problems starting WinSCP itself.
bei WinSCP.Session.Open(SessionOptions sessionOptions)
bei ST_1138412fae60475f9346f7177723cdda.ScriptMain.Main()
The program '[12000] DtsDebugHost.exe: DTS' has exited with code 0 (0x0).

Problem persists if I change log folder with Session.XmlLogPath.

Can you please help me how to solve this?

Thanks in advance!
Regards,
Martin

Reply with quote

martin◆ Site Admin
Joined:: 2002-12-10
Posts:: 41,441
Location:: Prague, Czechia

Re: Problems with SSIS and WinSCP Assembly 5.21.5

2022-11-28

How did you install WinSCP into your project? Please give us step-by-step instructions for reproducing the problem.

Reply with quote

Guest

Re: Problems with SSIS and WinSCP Assembly 5.21.5

2022-11-28 11:07

I downloaded latest WinSCP assembly from here: https://winscp.net/eng/downloads.php
WinSCP.exe and WinSCPnet.dll from download is located in a local directory on my client
WinSCPnet.dll has been installed to GAC from local directory
WinSCPnet.dll has been added to SSIS scripttask references from local directory
Session.Options: Hostname/Username/Password from Dts.Variables, HostKeyPolicy = Giveupsecurity...

If I try to connect to the host with WinSCP client instead of scripttask/assembly, it works without any problems. Is there a known issue or configuration with VisualStudio 2019 which I use to create SSIS package?

Regards,
Martin

Reply with quote

martin◆ Site Admin

Re: Problems with SSIS and WinSCP Assembly 5.21.5

2022-11-28

So it doesn't work for you even on your development machine when you execute the task from Visual Studio? (not only in "production")

Reply with quote

Guest

Re: Problems with SSIS and WinSCP Assembly 5.21.5

2022-11-28 13:37

It just does not work via Visual Studio.
When I run the SSIS package after a deploy on the server there are no problems with the execution.

Reply with quote

martin◆ Site Admin
Joined:: 2002-12-10
Posts:: 41,441
Location:: Prague, Czechia

Re: Problems with SSIS and WinSCP Assembly 5.21.5

2022-12-08

I appologise for my late answer. It took me while to find time to install SSIS.
I have followed the instructions from the documentation step-by-step using Visual Studio 2022:
https://winscp.net/eng/docs/library_ssis
And I did not have any problems. I've tried both AppDomain.AssemblyResolve and GAC approaches. Both work.
If you try this with a fresh project, does it work?

Reply with quote

Problems with SSIS and WinSCP Assembly 5.21.5