What is "sqlbulkcopy"

Sqlbulkcopy Allows you to efficiently bulk upload updates to an SQL Server table with data from another source.

Microsoft SQL Server includes a complete command-line utility called bcp to move data from one table to another, whether on a single server or between servers. The Sqlbulkcopy class allows you to write managed code solutions that provide similar functionality.There are other ways to load data into an SQL Server table (INSERT instructions, for example)but Sqlbulkcopy offers a significant performance advantage over them.

The Sqlbulkcopy class can be used to write data only to SQL Server tables.However, the data source is not limited to SQL Server; any data source can be used, how data can be loaded to an instance or a Datatable read with an Idatareader instance .

Sqlbulkcopy will fail when bulk loading a Sqldatetime type Datatable column in an SQL Server column whose type is one of the date/time types added in SQL Server 2008.