Truncate before SqlBulkCopy

Question

I want to truncate a table before doing a SqlBulkCopy. Does SqlBulkCopy automatically truncate a table before copying the data?

Answer 1

No, not to my knowledge.

I don't see any options on the SqlBulkCopy class that would allow you to instruct SqlBulkCopy to truncate before loading.

You'll have to do that yourself before launching SqlBulkCopy.

Answer 2

Is it possible to truncate the table from ado .net? Or do you need to call a stored proc to do that?