I have a question about SQLBulkCopy. Looking at the below code: When setting the DestinationTableName does that create a table in SQL Server? I understand that once the DestinationTableName is set then WriteToServer will BulkCopy data in the DataTable to the DestinationTableName.
SqlBulkCopy sqlcpy = new SqlBulkCopy(mySQLConnection);
sqlcpy.DestinationTableName = "myTable"
Any other info that I would need to be aware of is greatly appreciated.