Issue in using Smartsheet CSharp SDK in SSIS Package

01/22/21
Answered - Pending Review

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\aakanshi.bafna\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

Answers

Sign In or Register to comment.