How to transfer data from Cassandra to MS SQL?

Question

big data

Good day everyone!
There is a Cassandra database in which data is written at a rate of tens of thousands per second. There is a task of transferring this data to MSSQL (if possible, thinning it out on the way).
Having studied all the options, I try to apply MS SSIS and Cassandra ODBC driver from DataStax. For some reason, only about 10,000 records are exported at a time. In this case, the package does not produce any errors, but exits gracefully. In the documentation for the driver, I did not find a description of such a limitation anywhere.
Questions:
1. How to transfer more records at a time using SSIS
2. What other options can I have to solve my problem
Thanks in advance