Issue in using Smartsheet CSharp SDK in SSIS Package

Rajesh Lohar

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

Genevieve P.

Hi @Rajesh Lohar

I was searching the Microsoft Community to see if other users might have a suggestion for you and I see you asked the same question there. It looks like a member has responded to your post with a suggested solution and a link to this article: The located assembly's manifest definition doesn't match the assembly reference

If this didn't help, I would advise continuing the conversation on your other post, here in case that member has another solution for you.

Cheers,

Genevieve

Etienne Mermillod

Hi,

I would suggest to also add the Smartsheet dependent assembly to the GAC too, this does includes restsharp, and newtonsoft.json libraries.

Etienne

SmartyPantsSheets12

Where do I find the smartsheet CSharp SDK v2 DLL?

Trying to add it to GAC

Genevieve P.

Hi @SmartyPantsSheets12

You can find SDKs in the API Documentation:

https://smartsheet.redoc.ly/#section/API-Basics/SDKs-and-Sample-Code