SSIS 2022 CDC Control Task

Question

We get the following error when running SSIS packages that contain attunity CDC Control Tasks in our SQLServer 2022 environment on Windows2019 :

CDC Control Task:Error: The Validate method on the task failed, and returned error code 0x80131040 (Could not load file or assembly 'Microsoft.SqlServer.DtsMsg, Version=16.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)). The Validate method must succeed and indicate the result using an "out" parameter

Answer 1

Hi @Tom J,

As said in the documentation and also @Yitzhak Khabinsky mentioned:

The CDC components for SSIS are supported on all the supported versions of Microsoft SQL Server. Currently, the supported versions of SQL Server include SQL Server 2012 through SQL Server 2017.

It seems that the CDC component do not support SQL Server 2022 temprarily.

You may also raise the issue here to look for help from product team.

Regards，

Zoe Hui

---

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

Answer 2

Hi @Tom J,

I am not sure if the Attunity CDC Control Tasks are working on SQL Server 2022.

Check it out here: https://learn.microsoft.com/en-us/sql/integration-services/data-flow/cdc-flow-components?view=sql-server-ver16