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?
asked Apr 26, 2017 at 03:09 PM in Default