Topic "Might be SSIS, but thought I would post"

Author Message
pturner
[View user's profile]

Joined: 2012-05-01
Posts: 6
I am using a script task, within SSIS, using C# script. I have added a reference, via the browse tab, to the .net project. I am not seeing a warning after I do this. Every time I execute the package, I get:

Error: 0x1 at Get AllFiles: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IO.FileNotFoundException: Could not load file or assembly 'WinSCP, Version=1.0.0.235, Culture=neutral, PublicKeyToken=b5f19f5762436b89' or one of its dependencies. The system cannot find the file specified.
File name: 'WinSCP, Version=1.0.0.235, Culture=neutral, PublicKeyToken=b5f19f5762436b89'
at ST_58e2d54778c4410787b20466405ffe9e.csproj.ScriptMain.Main()

WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

--- End of inner exception stack trace ---
at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
at System.Type.InvokeMember(String name, BindingFlags invokeAttr, Binder binder, Object target, Object[] args, CultureInfo culture)
at Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTATaskScriptingEngine.ExecuteScript()

I see that there is a registry command, but that is for COM. I ran it anyway and I am still receiving this error. Is there another way I must register this dll?
Advertisements
pturner
[View user's profile]

Joined: 2012-05-01
Posts: 6
looks like i needed to run gacutil -i "C:\Program Files\WinSCP\WinSCP.dll" within the command prompt, as an admin, to get it to work.
Lino
[View user's profile]

Joined: 2012-04-05
Posts: 3
I could be wrong, but to use any assembly within SSIS, you need to install it into GAC, so this isn't WinSCP specific issue.
pturner
[View user's profile]

Joined: 2012-05-01
Posts: 6
Lino wrote:
I could be wrong, but to use any assembly within SSIS, you need to install it into GAC, so this isn't WinSCP specific issue.

My second post answered that Very Happy
martin
[View user's profile]
Site Admin
Joined: 2002-12-10
Posts: 24555
Location: Prague, Czechia
See
http://winscp.net/eng/docs/library_ssis
Advertisements

You can post new topics in this forum






Search Site

What is WinSCP?

It is award-winning SFTP client, SCP client, FTPS client and FTP client integrated into one software program for file transfer to FTP server or secure SFTP server. [More]

And it's free!

Donate

About donations

$9   $19   $49   $99

About donations

Recommend

WinSCP Privacy Policy

WinSCP License