WinSCP no longer working within SSIS Script Tasks

Advertisement

Guest

WinSCP no longer working within SSIS Script Tasks

I have some existing SSIS packages that have been working using WinSCP within a Script Task to send/receive files using SFTP.

The SSIS packages are now throwing an error when attempting to execute the script task. The debugger is not available as the script task cannot be instantiated.

Error: Exception has been thrown by the target of an invocation.
Within the script editor the Code Analysis tool (Menu > Build > Run Code Analysis on...) produces the following issue:

'ScriptMain' is marked ComVisible(true) but has the following
ComVisible(false) types in its object hierarchy: 'VSTARTScriptObjectModelBase'
I tried decorating the class and Main method with [ComVisible(false)] which did not work.

WinSCP v5.9.6 (no longer works using SSIS 2012).

How can I resolve this issue?

Reply with quote

Advertisement

Guest

Yes I posted here because the users in this forum are probably more experienced implementing WinSCP in SSIS and I have not gotten any positive results with StackOverflow

Reply with quote

martin
Site Admin
martin avatar
Joined:
Posts:
27,253
Location:
Prague, Czechia

I've asked you for additional information on Stack Overflow and you have never responded!
_________________
Martin Prikryl

Reply with quote

Advertisement

You can post new topics in this forum