I am using JDBC sink connector in Kafka Confluent tool to load data from a topic to a table in SQL Server database. Due to mismatch in length between source and target field, I am getting an error which says:
String or Binary data would be truncated for the field-X in table-xyz in database-abc (SQL Server).
Is there a setting or any JDBC connection URL configuration available in Kafka connector to allow the data to load in the target table without erroring out the record or routing the record to the dead letter topic?
Thanks.