Could not load file or assembly 'Microsoft.SqlServer.ConnectionInfo, Version=12.0.0.0

hello,

I am upgrading to the latest TX and SQL 2022. When I want to deploy my project I get following error:

Location: Business Unit 'BU_CRH'.

Details:

Could not load file or assembly 'Microsoft.SqlServer.ConnectionInfo, Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
Module: TimeXtender.Sql.Engine.2014
System.IO.FileNotFoundException
at TimeXtender.Sql.Engine.SqlEngineBase.InitializeFromSqlServer(SqlServer sqlServer)
at TimeXtender.DataManager.DataSource_Sql.GetSqlEngine(Boolean startTransaction, Boolean singleConnection)
at TimeXtender.DataManager.StepTableStructureRawDeploy.DoAbstractStep(StepSetup stepSetup)

Details of the SQL:

Microsoft SQL Server 2022 (RTM-CU13-GDR) (KB5040939) - 16.0.4131.2 (X64)
Jun 21 2024 21:57:17
Copyright (C) 2022 Microsoft Corporation
Standard Edition (64-bit) on Windows Server 2022 Standard 10.0 <X64> (Build 20348: ) (Hypervisor)

Any suggestion how to solve this.

Thanks,

Ronny

Page 1 / 1

Hi,

it is looking for SQL 2014 dlls - I assume you are running 20.10.41 or higher as that is required for SQL Server 2022 support. Could it be that your databases are still running under older compatibility mode or that your settings are hard-setting the target version of SQL for your BU layer? You may need to change those to auto.

hello Rory,

Thanks, we set the compatibility to 2019 and it works.

Now up to the next error when trying to deploy my first table:

Error creating DTS package for dbo.AX_CRH_A_dbo_DATAAREA
Exception from HRESULT: 0xC020801C

If you know the solution let me know, in the meantime I will google it.

Regards,

Ronny

Hi,

there should be more details available for the error that should give you more hints about what is going wrong. The error is an SSIS error: if you are not using (or wanting to use) SSIS, you should change settings to use ADO.Net. These settings can live at the project, BU/DWH, Source level and inherit downwards. If you are usign SSIS you will need to redeploy all packages because you are jumping from 2014 to 2022 SSIS, there could be alot of changes if your original packages were generated in even older versions of SSIS.

The error itself seems to indicate that the source defined for the package (in this case an AX table in source) cannot be reached by SSIS itself.

@rluyten which version of TimeXtender are you using? Which version of SSIS do you have installed on the application VM? can you please try to synchronize your data source and do a full load of the table by deploying the table and then clicking review tasks and then checking the deploy step and clicking start (please note this will truncate table and require a full load if it is an incremental table)?