Clickhouse ODBC Destination SSIS batch size issue.

[artasheskhachatryan1991]

I create SSIS project with MSSQL as Source and Clickhouse as ODBC destination. The destination table have a single ID Int64 column. I set "Data access mode" to "Table Name - batch" and "Rows per batch" to 1000. The source component is simple

select top (1000) Id
from table.

The execution of data flow finish without errors, but only a single row is inserted (instead if 1000). The destination table Engine is MergeTree. If I change the "Rows per batch" from 1000 to 50, 20 rows are inserted.
So it seems like number of actual inserted rows = Number Of rows in Source Component / "Rows per batch".

I use Clickhouse ODBC driver 1.1.10, clickhouse version is 23.12.2.59.

[den-crane]

odbc repo https://github.com/ClickHouse/clickhouse-odbc/issues