SQL Server CDC Client: The column name __$command_id is not valid.

Issue:

Pipeline with SQL Server CDC Client failing with:

com.microsoft.sqlserver.jdbc.SQLServerException: The column name __$command_id is not valid.

Solution:

This seems to be an issue with SQL Server - https://ask.streamsets.com/question/1811/jdbc_78-the-column-name-__command_id-is-not-valid/:

This seems to be an issue with SQL Server - one user was able to get around this error by applying SQL Server 2012 SP3 CU 10, which includes a fix for KB4038210.