Posted by Erland Sommarskog on 09/08/06 21:58

Thyagu (tdelli@gmail.com) writes:
> Is there any .NET package/module/assembly for BCPing the data into SQL
> Server.
> The BULK INSERT utility works fine, but we are kind of worried on
> placing the data.
>
> If there is any utility to build the data into a data structure and BCP
> in into the SQL Server, please let know. It would be of great use.

SqlClient has classes for bulk-copying. I have not used it, but a quick
look in MSDN Library telles me that you write from a datarow.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: SQL Server 2K Database Name Problem
• Prev in forum: Re: Creating a dynamic Global Temp Table within a stored procedure
• Thread view: Re: .NET assembly for BULK INSERT

[Reply to this message]