CODEWITHSUNDEEP
ssiscdc
Sean Saúl Astrakhan
Sean Saúl Astrakhan

Reputation: 155

CDC control task error "There is no change data for this table" in SSIS

When I try to run the SSIS task "CDC Control Task" with the operation "Get Processing Range" to begin an incremental load of data, I get the "There is no change data for this table" error.

enter image description here

I have CDC enabled on the table and everything works fine with SSIS and CDC on the initial load with the "Mark initial load start".

I'm following this tutorial: https://www.youtube.com/watch?v=FJSvKgfXgtk&t=318s

Upvotes: 1

Views: 935

Answers (1)

Sean Saúl Astrakhan
Sean Saúl Astrakhan

Reputation: 155

Turned out the SQL Server Agent was turned off and wasn't processing anything. If your [table_name]_CT table (under 'System Tables') that probably means your Agent is off too.

Upvotes: 4

Related Questions