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
commented
2 weeks ago
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.