Issue in using Smartsheet CSharp SDK in SSIS Package
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
-
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
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
Hi,
I would suggest to also add the Smartsheet dependent assembly to the GAC too, this does includes restsharp, and newtonsoft.json libraries.
Etienne
-
Where do I find the smartsheet CSharp SDK v2 DLL?
Trying to add it to GAC
-
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 303 Events
- 34 Webinars
- 7.3K Forum Archives