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.