locked
SSIS, SQL Agent & CDC RRS feed

  • 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

  • No, even in Version 2017 of SSIS you can use Attunity CDC Task only with Enterprise Edition, not in Standard.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]


    • 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 also
    Thursday, 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

    In SSIS you can run SQL script and with SQL you can access all CDC tables to process the data.

    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
  • No, even in Version 2017 of SSIS you can use Attunity CDC Task only with Enterprise Edition, not in Standard.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]


    • 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