SQLServerBulkCopy destination column metadata is caching but is not reusing the results, so metadata calls are repeated
tkyc opened this issue · 0 comments
tkyc commented
When performing a bulk insert, the driver does a destination column metadata query. However, this metadata query is repeated if the bulk insert is repeated. It isn't necessary to repeat the call if the destination columns did not change.
The metadata query being ran is the following:
select collation_name, encryption_type from sys.columns where object_id=OBJECT_ID('table') order by column_id ASC