question

tlenzmeier avatar image
tlenzmeier asked

SS 2016 SSIS Change Data Capture Issue

We recently upgraded to SQL Server 2016, standard edition, and our CDC SSIS packages started failing. The CDC Source object fails every time we attempt to run our packages. Microsoft has acknowledged the issue (we have tried their recommended work arounds): https://blogs.msdn.microsoft.com/sql_server_team/cdc-functionality-may-break-after-upgrading-to-the-latest-cu-for-sql-server-2012-2014-and-2016/ Given that we do not know when the issue will be resolved, does anyone have ideas on how to utilize the CDC data? Thanks.
ssissql-server-2016change-data-capture
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.