Click here to Skip to main content
15,867,756 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
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.

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


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://docs.microsoft.com/en-us/sql/integration-services/data-flow/cdc-flow-components?view=sql-server-ver15[^]

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.

What I have tried:

Tried Deploying package again after moving from enterprise edition to standard edition.
Posted
Updated 29-Sep-20 22:21pm
v2

1 solution

This is a problem with the Microsoft documentation - the feature requires Enterprise edition, but this is not mentioned in the documentation.

Even if you don't believe the error message for some reason, other sources will confirm that CDC only works in Enterprise edition. For example:
Change Data Capture (CDC) is a feature of SQL Server Enterprise Edition ...
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900