SSIS .net c#script task crashes on startup

  • 1
  • Problem
  • Updated 5 months ago
Hi,

I am looking to implement a simple send file to sharefile folder function in SSIS VS 2015 . I have used the latest console sample and removed the Async parts . I have build the scv library with VS 2017 and am using the net45 set of dlls that are built in the bin directory.

When I try and run the simple script task it is bombing out before I have even got to the first line with a breakpoint. Stacktrace below ....

   at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
   at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
   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 Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTATaskScriptingEngine.ExecuteScript()

These leads me to believe I am either missing a reference or got an incompatibility problem. Any one got any ideas..?

Here are the imports, is there anything missing or particularly stupid I am doing ? (leading with the chin)... :-)

#region Namespaces
using System;
using System.Data;
using Microsoft.SqlServer.Dts.Runtime;
using System.Windows.Forms;
using System.IO;
using System.Linq;
using ShareFile.Api.Client;
using ShareFile.Api.Client.Extensions;
using ShareFile.Api.Client.Logging;
using ShareFile.Api.Client.Models;
using ShareFile.Api.Client.Security.Authentication.OAuth2;
using ShareFile.Api.Client.Transfers;
#endregion


Kind regards

Richard
Photo of Richard D Hudson

Richard D Hudson

  • 8 Posts
  • 0 Reply Likes

Posted 5 months ago

  • 1
Photo of Richard D Hudson

Richard D Hudson

  • 8 Posts
  • 0 Reply Likes
.. Just to add a  little more information . I have tried to rebuild in VS 2010 . The Sharefile.Api.Client Dll appears to be there in object browser , but if I build the script/snippet then the reference disappears. This is would explain the behaviour in VS 2015. Could anyone give me the happy path for this please ?

Many thanks

Richard
Photo of Richard D Hudson

Richard D Hudson

  • 8 Posts
  • 0 Reply Likes
.. Ok will use FTP as much easier... does anyone know how I use secure FTP say in Filzilla ? I can connect normally but if I try to use "Require explicit FTP over TLS" then the connection fails . I set the port to 990...

Anyone , anyone ? :-)

Richard