Answered by:
SSIS, SQL Agent & CDC

Question
-
I have a SQL Server 2016 SP1 Standard Edition server. I have developed a basic CDC package on the server as I have also installed SSDT onto the server also. I know this is not best practice btw :-)
Anyway, my understanding is that SQL Server 2016 SP1 supports CDC.
The package will run fine through SSDT, but when I try and schedule to package on my 2016 SP1 SQL Server, to which is running on the same machine I developed the package on, the package errors through SQL Server Agent with message 0xC0012024 - stating that I cant run the package on the current version and need at least Enterprise Edition ?
Any thoughts/ideas would be great.
Many Thanks
Thursday, February 14, 2019 10:25 AM
Answers
-
- Edited by Olaf HelperMVP Thursday, February 14, 2019 12:41 PM
- Marked as answer by DBA1995 Thursday, February 14, 2019 12:54 PM
Thursday, February 14, 2019 12:40 PM
All replies
-
P.S. I do have Integration Services installed on the server alsoThursday, February 14, 2019 10:27 AM
-
Hello,
As the error message indicates, CDC components is not supported by Standard edition.
Please check this link:
Integration Services features supported by the editions of SQL Server
MSDN Community Support Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com
- Proposed as answer by Olaf HelperMVP Thursday, February 14, 2019 11:30 AM
Thursday, February 14, 2019 10:46 AM -
OK Thanks for the reply.
So there is no way of scheduling a SSIS package to process CDC data on SQL Server 2016 SP1 Standard Edition ?
Although CDC works on 2016 SP1, you can only enable CDC but cant do anything with the data via SSDT ?
Thanks
Thursday, February 14, 2019 11:37 AM -
So there is no way of scheduling a SSIS package to process CDC data on SQL Server 2016 SP1 Standard Edition
Olaf Helper
[ Blog] [ Xing] [ MVP]Thursday, February 14, 2019 12:02 PM -
Thanks. But I cant use CDC with SSDT to run the package on SQL Server 2016 SP1 ?Thursday, February 14, 2019 12:06 PM
-
- Edited by Olaf HelperMVP Thursday, February 14, 2019 12:41 PM
- Marked as answer by DBA1995 Thursday, February 14, 2019 12:54 PM
Thursday, February 14, 2019 12:40 PM -
Thanks for the confirmation Olaf. Very much appreciated.
I will look into a custom SQL script solution.
Thursday, February 14, 2019 12:53 PM