In this blog, we will be addressing the problem with CDC implementation in SSIS package which goes with the error
‘invalid column name __$command_id’
CDC stands for the change data capture. It was introduced in SQL server 2012. In SSIS package we have CDC control flow task and CDC source and CDC destination in Data flow task. CDC processing logic split into two packages – an
package that will read all the data in the source table, and an
package that will process change data on subsequent runs.
While previewing the CDC source task in an incremental package load, we get the error: ‘invalid column name __$command_id’