Name of the destination table on the server.
Syntax
Value
Documentation for this section has not yet been entered.
Remarks
If SqlBulkCopy.DestinationTableName has not been set when erload:System.Data.SqlClient.SqlBulkCopy.WriteToServer is called, an ArgumentNullException is thrown.
If SqlBulkCopy.DestinationTableName is modified while a erload:System.Data.SqlClient.SqlBulkCopy.WriteToServer operation is running, the change does not affect the current operation. The new SqlBulkCopy.DestinationTableName value is used the next time a erload:System.Data.SqlClient.SqlBulkCopy.WriteToServer method is called.
SqlBulkCopy.DestinationTableName is a three-part name (<database>.<owningschema>.<name>). You can qualify the table name with its database and owning schema if you choose. However, if the table name uses an underscore ("_") or any other special characters, you must escape the name using surrounding brackets as in ([<database>.<owningschema>.<name_01>]). For more information, see "Identifiers" in SQL Server Books Online.
You can bulk-copy data to a temporary table by using a value such as tempdb..#table or tempdb.<owner>.#table for the SqlBulkCopy.DestinationTableName property.
Requirements
Assembly: System.Data (in System.Data.dll)
Assembly Versions: 2.0.0.0