Quick answer: This SSIS error can occur when an SSISDB database restored to another SQL Server instance cannot load the SSIS server assembly because the target instance is not prepared for the SSISDB catalog. Recreating the SSISDB catalog on the target server and migrating the SSIS projects is the preferred approach when a clean migration is possible.
Error
An error occurred in the Microsoft .NET Framework while trying to load assembly id 65536. The server may be running out of resources, or the assembly may not be trusted. For more information about this error:
System.IO.FileLoadException: Could not load file or assembly ‘microsoft.sqlserver.integrationservices.server, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91’ or one of its dependencies. An error relating to security occurred. (Exception from HRESULT: 0x8013150A).
Cause
The issue can occur when an SSISDB backup is restored to another SQL Server instance where the SSIS Catalog has not been created or the required SSIS assemblies and security configuration are not available on the target instance.
Solution
Recommended: If you are migrating SSIS workloads to another SQL Server, create a new SSISDB catalog on the target server and migrate the SSIS projects and environments instead of restoring an SSISDB created on a different instance.
If you need to restore SSISDB to a target instance, follow Microsoft’s SSIS Catalog restore procedure. The required preparation depends on whether the target instance already has an SSIS Catalog.
For a migration between SQL Server instances, you can also use the SSIS Catalog Migration Wizard to migrate SSIS projects and related catalog objects.
See more
Visual Studio Marketplace
SSIS Catalog Migration Wizard
Extend Visual Studio with an easy way to migrate SSIS Catalog projects.
Kunal Rathi
With over 15 years of experience in data engineering and analytics, I've assisted countless clients in gaining valuable insights from their data. As a dedicated supporter of Data, Cloud and DevOps, I'm excited to connect with individuals who share my passion for this field. If my work resonates with you, we can talk and collaborate.
