question

sakuraime avatar image
0 Votes"
sakuraime asked OuryBa-MSFT commented

SSIS CDC Control task Question

I have two questions .

  1. I am using visual studio 2019 , and while I try to preview the CDC source , it throws the following error, any idea ? is there any driver missing ? However, actually the package can be running successfully by debug
    115594-image.png

  2. Anyone knows if are there any corresponding TSQL for the following task in CDC control flow ?
    115517-image.png


  3. If the initial load start ( full load of the table ) , the source table can be modified during the full load, coz the full load may need hours and days.? In this case , should I put 'Mark CDC start' at the beginning of the full load ?

  4. Anyone has tried to put the ssis CDC control flow package into Azure Data factory SSIS runtime to execute ? Are there any things need to install to the Azure Data factory SSIS runtime




sql-server-generalazure-data-factorysql-server-integration-services
image.png (154.7 KiB)
image.png (45.4 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

sakuraime avatar image
0 Votes"
sakuraime answered

anyone has the idea ?

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered OuryBa-MSFT commented

Hi @sakuraime,

1.It seems is a known issue, please check the version of the SSIS and refer below KB to resolve the issue.

kb4500595-fix-cdc-source-preview-fails-with-the-given-key-was-not-present-in-the-dictionary-error-in-sql-server-2017-465162b7-f42f-2fca-886e-20d81eaa03b6

kb4490435-fix-the-given-key-was-not-present-in-the-dictionary-occurs-if-you-do-a-preview-in-the-cdc-source-in-sql-server-2016-32ef3e95-8e54-fcaf-978e-9b4b4f1a5306

2.CDC control related you may refer:

cdc-flow-components
https://www.mssqltips.com/sqlservertip/5815/sql-server-integration-services-ssis-cdc-tasks-for-incremental-data-loading/

3.SSIS has the CDC extract and apply functionality built-in, and you can run SSIS CDC data flows either on your on-prem SQL Server, or in an ADF SSIS runtime.
https://docs.microsoft.com/en-us/sql/integration-services/control-flow/cdc-control-task?view=sql-server-ver15

Regards,

Zoe


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.
Hot issues October


· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @sakuraime, Did the answered proposed by Zoehui helped resolve the issue? Please let us know if you have any questions

Regards,
Oury

0 Votes 0 ·

Hi @sakuraime Was the answer provided above helped you resolve your issue?

Regards,
0ury

0 Votes 0 ·