SqlBulkCopy Tutorial - Knowledge Base (KB)

SqlBulkCopy XML with a GUID foreign key

I am tryin to insert data using XML files and SqlBulkCopy. The destination table is a time series table set up as below...create table TimeSeries ( Id uniqueidentifier constraint DF_TimeSeries_Id default (newid()) not null, ObjectId un...

SqlBulkCopy dbnull.value error

I am trying to insert rows from an excel file into sql server 2000 using bulkcopy. In the table there is a 'rowguid' field and its default value is set to (newid()) and cannot except null values. Also RowGUID is set to "Yes". ...In my code i remove the co...