Might be SSIS, but thought I would post

Advertisement

pturner
Joined:
Posts:
6

Might be SSIS, but thought I would post

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?

Reply with quote

Advertisement

pturner
Joined:
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.

Reply with quote

Lino
Joined:
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.

Reply with quote

pturner
Joined:
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 :D

Reply with quote

Advertisement

You can post new topics in this forum