|
|
Posted by Dan Guzman on 09/10/06 13:47
To add to Erland's response, the SqlBulkCopy class was introduced with .Net
Framework 2.0 (VS 2005 et. al.). SqlBulkCopy includes a WriteToServer
method that allows you to pass a DataTable, DataRow array or IDataReader.
The ColumnMappings property specifies the mappings between source and
destination columns.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Thyagu" <tdelli@gmail.com> wrote in message
news:1157727628.683912.128730@b28g2000cwb.googlegroups.com...
> Hi,
>
> 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.
>
> Let know if I should post this elsewhere
>
> Regards,
> Thyagu
>
>
Navigation:
[Reply to this message]
|