I am working on a requirement - Upload files to SharePoint using Client Id and Secret. I struct at Nuget package usage in SSIS Script Task.
Here what I have tried,
Copied all the DLLs to a location and used below code,
public ScriptMain()
{
AppDomain.CurrentDomain.AssemblyResolve += new ResolveEventHandler(CurrentDomain_AssemblyResolve);
}private System.Reflection.Assembly CurrentDomain_AssemblyResolve(object sender, ResolveEventArgs args)
{
string strAssemblies_Location = @"C:\Users\siva.m\Documents\SSIS Helper Packages\2.0\";
return System.Reflection.Assembly.LoadFrom(strAssemblies_Location);
}
then my code to connect SharePoint. It is not working and throwing the below error,
Error: 0x1 at Script Task 1: Could not load file or assembly 'PnP.Framework, Version=1.5.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified.
Task failed: Script Task 1
Any help on this issue, Please?