 <p>The method Add on ColumnMappings collection allows you to map your columns from source table to destination table. The method ColumnMappings.Add accepts four different ways to map your columns.</p> <p>SQLBulkCopy is very much strict on data type of both the columns which you have to consider while adding it to ColumnMappings collection</p>