Hi @machavan
Thanks for resolving the issue, I want to know one more thing what method Microsoft recommend to load data to the target mssql table We have seen some gain with using SqlServerBulkCopy api and using ISqlServereBulkRecord against loading data using the same class using csv file.
Would really appreciate if you could answer this query.

Hi @machavan Thanks for resolving the issue, I want to know one more thing what method Microsoft recommend to load data to the target mssql table We have seen some gain with using SqlServerBulkCopy api and using ISqlServereBulkRecord against loading data using the same class using csv file. Would really appreciate if you could answer this query.

Hi @yatharthgovil

Yes, bulk Copy offers a significant performance advantage.

Please refer:
Bulk Copy: https://learn.microsoft.com/en-us/sql/connect/jdbc/using-bulk-copy-with-the-jdbc-driver?view=sql-server-ver16

and

Bulk Copy API for Batch Insert: https://learn.microsoft.com/en-us/sql/connect/jdbc/use-bulk-copy-api-batch-insert-operation?view=sql-server-ver16

Hi @machavan can you please let us know when this will be available for us to consume also whats the plan will this fix be available with the next version release? if so can you please let us know when is that planned also will it be a minor version upgrade or a major version upgrade?
We would like to know the ETA for when its avaialble for us to consume.

Hi @machavan can you please provide clarification for the concern I have mentioned in the previous comment or provide any ETA for the same?

Hi @machavan can you please let us know when this will be available for us to consume also whats the plan will this fix be available with the next version release? if so can you please let us know when is that planned also will it be a minor version upgrade or a major version upgrade? We would like to know the ETA for when its avaialble for us to consume.

Hi @yatharthgovil

We will look to include this fix in the next release, will update you shortly on the timeline for the same.

Codecov Report

All modified and coverable lines are covered by tests ✅

Project coverage is 51.24%. Comparing base (08cd6fd) to head (a2620e8).
Report is 1 commits behind head on main.

@@             Coverage Diff              @@
##               main    #2575      +/-   ##
============================================
+ Coverage     51.22%   51.24%   +0.02%     
- Complexity     3953     3968      +15     
============================================
  Files           147      147              
  Lines         33657    33657              
  Branches       5624     5624              
============================================
+ Hits          17241    17248       +7     
- Misses        13999    14003       +4     
+ Partials       2417     2406      -11     

☔ View full report in Codecov by Sentry.
📢 Have feedback on the report? Share it here.

ADO tests passed for this PR.

Hi @machavan
can you please let us know your plan for next version release as to when the release with this fix included will be released. We would like to know when is it planned ?

Hi @machavan can you please let us know your plan for next version release as to when the release with this fix included will be released. We would like to know when is it planned ?

Hi @yatharthgovil , We are planning for a release around Feb end/March start