Problems with SSIS and WinSCP Assembly 5.21.5

Advertisement

mkfromhighlands
Joined:
Posts:
1
Location:
Luxembourg

Problems with SSIS and WinSCP Assembly 5.21.5

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

Advertisement

martin
Site Admin
martin avatar
Joined:
Posts:
38,408
Location:
Prague, Czechia

Re: Problems with SSIS and WinSCP Assembly 5.21.5

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

  • 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
martin avatar

Re: Problems with SSIS and WinSCP Assembly 5.21.5

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

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

Advertisement

martin
Site Admin
martin avatar
Joined:
Posts:
38,408
Location:
Prague, Czechia

Re: Problems with SSIS and WinSCP Assembly 5.21.5

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

Advertisement

You can post new topics in this forum