Handling Empty Strings in SQL Bulk Insert

I don't have the time to test this right now, but what happens if you try BCP instead?

The check constraint would work if you set BATCHSIZE=1, but that would slow down things a bit.

---

Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se