Specifies whether the provider truncates the target table before performing each batch insert operation.

Syntax

Connect-CSV -TruncateOnInserts SwitchParameter

Data Type

bool

Default Value

false

Remarks

When this property is set to true, the cmdlet removes all existing data from the target table before executing each batch insert. When set to false, new rows are appended without truncating existing data.

This property is useful for replacing table data entirely during batch insert operations.