|
|
Posted by Thyagu on 09/11/06 06:26
Thanks very much guys. This is awesome!
Regards,
Thyagu.
Dan Guzman wrote:
> 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]
|