Issue in using Smartsheet CSharp SDK in SSIS Package

• rajeshlohar

  SSC Veteran

  Points: 219

  More actions

  January 27, 2021 at 8:32 am

  #3837911

  Hi,

  I am using Smartsheet CSharp SDK in SSIS Script Task. I added it by nuget package, but getting error as below :

  Error CS0246 The type or namespace name 'Smartsheet' could not be found (are you missing a using directive or an assembly reference?)

  Then, I downloaded Smartsheet CSharp SDK and added reference to the dll and put the dll to GAC, but I am getting error as below:

  System.IO.FileLoadException HResult=0x80131040 Message=Could not load file or assembly 'RestSharp, Version=106.6.9.0, Culture=neutral, PublicKeyToken=598062e77f915f75' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040) Source=smartsheet-csharp-sdk StackTrace: at Smartsheet.Api.Internal.SmartsheetImpl..ctor(String baseURI, String accessToken, HttpClient httpClient, JsonSerializer jsonSerializer, Boolean dateTimeFixOptOut) at Smartsheet.Api.SmartsheetBuilder.Build() at ST_4c8743940e6440cf86e837c68e7b0b9a.ScriptMain.Main() in c:\Users\xxxxxxx\AppData\Local\Temp\Vsta\0da5e809811b421fb328961fd7cda64a\ScriptMain.cs:line 123 Inner Exception 1: FileLoadException: The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)

  Please suggest a solution how to use smartsheet csharp SDK in SSIS Script Task.

  Thanks

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  January 28, 2021 at 9:10 am

  #3838284

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.