'cdc control task' cannot run on the installed version of the integration services.

Sandeep Kumar 21 Reputation points
2020-09-30T07:37:48.617+00:00

Hi,

I have deployed SSIS package on SQL SERVER 2019 Standard Edition(Version : 15.0.200) and package is using CDC control Flow task.
Now, when I execute the package it's getting below error.

29371-cdc1.png

""'cdc control task' cannot run on the installed version of the integration services. It requires enterprise edition (64-bit) or more.""
29362-cdc2.png

CDC is working on standard edition version and all the data changes are getting captured in CDC tables. But we are seeing this error when I execute the package.

I've gone through below article, and It is mentioned that SQL SERVER 15x is supporting cdc flow components but nothing mentioned about Editions .

https://video2.skills-academy.com/en-us/sql/integration-services/data-flow/cdc-flow-components?view=sql-server-ver15

below is the reference image of sample package.

29372-cdc3.jpg

any suggestions to sort out this error should be really appreciated.

If cdc control task is only supported in enterprise edition then please provide any alternative solutions to process CDC data through SSIS.

Thanks in advance.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,784 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,576 questions
0 comments
Accepted answer
  1. Monalv-MSFT 5,901 Reputation points
    2020-09-30T09:19:42.607+00:00

    Hi @SandeepKumar-1780,

    The Change Data Capture components by Attunity require Enterprise edition.

    Please download Enterprise edition and set Run64BitRuntime as True in the SSIS package.

    Hope the following links will be helpful:

    Integration Services - Advanced tasks and transformations

    SSIS Packages in 64-Bit

    Best Regards,
    Mona

    ----------

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

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