Issue Deploying SSIS Package

1

I am working at a small company with no DBA but we use SQL Server for reporting. I'd like to get SSIS up and running for some ETL and back end processes. I used to develop in the past so have some basic skills but no DBA experience at all. I've been able to get SSIS installed at least I see the integration services folders and the SSIS database. But after working through what I thought were security issues and getting CLR enabled I'm receiving the following message. Thought I'd ask this group as I start to research to see if anyone had a quicker answer.

We are using SQL Server version 2019, Visual Studio 2019 and SSMS version 15.

TITLE: SQL Server Integration Services
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. Run the query again, or check documentation to see how to solve the assembly trust issues. For more information about this error: System.IO.FileLoadException: Could not load file or assembly 'microsoft.sqlserver.integrationservices.server, Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. An error relating to security 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) (Microsoft SQL Server, Error: 10314)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=15.00.2000&EvtSrc=MSSQLServer&EvtID=10314&LinkId=20476

sql-server
deployment
ssis
asked on Stack Overflow Mar 24, 2021 by Steve • edited Mar 24, 2021 by Dale K

1 Answer

0

The SSIS is installed using the same installation package as the sql server.Sql server version and SSIS version mismatch and thats why the SSISDB is having issues.

answered on Stack Overflow Apr 6, 2021 by swapnil

User contributions licensed under CC BY-SA 3.0