Import-DbaCSV

[dczarny]

---

name: Import-DbaCsv without a single transaction 💣
about: I would like the ability to load data to a staging table using import-dbacsv without being in a single transaction. I would like for the batchsize to control the transaction size with the sqlbulkcopy.

---

Summary of new feature

The problem I would like to solve with the batchsize is to control the size of the transaction log with smaller transactions. When loading to a stage table, the single transaction is not necessary because if there is an issue, I can just truncate the table and not wait for the rollback. Would still like the ability to have the single transaction when loading to a table that is not a staging table and don't have the ability to just truncate.

Proposed technical details (if applicable)

Discussed in Slack thread.

Latest version of dbatools as of writing

0.9.771