Forum » .NET assembly / COM library »

Post a reply

Username

Subject

Message body

Font colour:

Font size:

Options

Disable BBCode in this post

Notify me when a reply is posted (registered users only)

Add an Attachment

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

Filename

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

File Comment

Options

Private file (available to author and site moderators only)

Topic review

martin

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?

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.

martin

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

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

martin

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.

mkfromhighlands

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