Deploying/Executing a deployed SSIS package

Question

Hello,

I have an SSIS package that I have deployed under an SSIS catalog : SSISDB.

When I want to execute the deployed package from SSMS it drops me this error :
"An error occurred in Microsoft .NET Framework while attempting to load assembly ID 65536. The server resources are insufficient or the assembly may not be approved. Please retry the request or consult the documentation to learn how to resolve assembly approval issues. For more information about this error, refer to: System.IO.FileLoadException: Could not load file or assembly 'microsoft.sqlserver.integrationservices.server, Version=15.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. A security-related error occurred. (Exception from HRESULT: 0x8013150A) System.IO.FileLoadException: at System.Reflection.RuntimeAssembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks) at System.Reflection.RuntimeAssembly.InternalLoadAssemblyName(AssemblyName assemblyRef, Evidence assemblySecurity, RuntimeAssembly reqAssembly, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks) at System.Reflection.RuntimeAssembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean forIntrospection) at System.Reflection.RuntimeAssembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) at System.Reflection.Assembly.Load(String assemblyString) (.Net SqlClient Data Provider)"

I granted the rights for the user to access the folder where the DLLs are located and the rights to read and modify on the DLLs.

Anyone encountered this issue ?

Thank you for your help.

Answer 1

Hi @Marwen BENSLIMENE,

Please first check whether we have SQL Server Integration Services installed. In order to do that, navigate to Start > Run > Services.msc > OK. Then locate the SQL Server Integration Services service and ensure it is running.

If Integration Services is not present, we have to go ahead with the installation.

Check: Install Integration Services (SSIS)

If this does not work, please re-deploy the package for a try. Remember to select the correct target server version.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.