Post a reply

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

martin

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?
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.
martin

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")
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
martin

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

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