Share via

SSIS 2022 CDC Control Task

Tom J 40 Reputation points
2023-02-14T15:09:14.8666667+00:00

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

SQL Server Integration Services
Windows for business | Windows Server | User experience | Other
Answer accepted by question author
  1. ZoeHui-MSFT 41,506 Reputation points
    2023-02-15T05:36:52.09+00:00

    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.

    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Yitzhak Khabinsky 27,011 Reputation points
    2023-02-14T16:12:11.94+00:00

    Hi @Tom J,

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

    Check it out here: https://free.blessedness.top/en-us/sql/integration-services/data-flow/cdc-flow-components?view=sql-server-ver16

    1 person found this answer helpful.
  2. Tiago Elias 0 Reputation points
    2025-09-29T19:14:24.0633333+00:00

    Hello, to solve this issue, you have to install cumulative update for sql server 2022 (https://free.blessedness.top/en-us/troubleshoot/sql/releases/sqlserver-2022/cumulativeupdate1, https://www.microsoft.com/en-us/download/details.aspx?id=105013).

    Best Regards,

    Tiago Elias

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.