Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Hi all, I hava a SqlServer2008R2, when I use 2.7.2.1 it is OK to CDC. But after updating to 3.5.2, I meet the same issue. I'm sure this is caused by a bug of StreamSets: https://github.com/streamsets/datacollector/commit/59eb06a6efaeb2b26bc386bc7f8f8dc448ae2ada#diff-57d2203727615dd81589770e1774c276

Because in SqlServer2008, cdc tables do not have a __$command_id column. You should check the version of sqlserver, then decide the columns for JDBC.

Btw, I'm in China so it is very difficult to sign this site's account because of the Great Firewall. Could you remove the validation image or change another provider...