Bulk Copy with SQL Variant type fails due to null sourceResultSet about mssql-jdbc

[lilgreenbird]

hi @hchenatsafe

We do have tests for bulkcopy using the SQL Variant type, what are you doing different? Could you please provide us with a repro of the issue?

[hchenatsafe]

Hi @lilgreenbird, thanks for following up!

Your tests seem to be using writeToServer(ResultSet sourceData), which wouldn't run into this issue since sourceResultSet would be set here.

Our application passes a source data object that implements ISQLServerBulkData, so we are using writeToServer(ISQLServerBulkData sourceData) where sourceResultSet seems to be set to null, and we run into this error when writeSqlVariant() is called

[lilgreenbird]

@hchenatsafe

Could you please include your repro code here along with the schema and connection string used

[hchenatsafe]

It seems it would be a challenge to untangle our source to provide a clean repro. We'll leave this issue up to your consideration. Thanks for your assistance!

[lilgreenbird]

thanks @hchenatsafe I can see in the code path that this would be an issue. Looks like this had been an issue since day 1, I will add this as an enhancement and add a note in the doc that this isn't supported right now. Thanks for reporting the issue to us!

[typhoon2k]

Facing the same issue. It's a blocker for implementing data transfer pipelines into tables having SQL Variant columns.