While using SqlBulkCopy to load data into a SQL Server 2005 database,
I've noticed an occasional exception that is saying one of the fields
in my DataTable object contains a null value and this is failing the
not null constraint on the table.

When I set up the DataTable object prior to the bulk insert I simply
set this field to an integer value, so it is never null in my code.
I've even put in some validation code on the DataTable object that runs
prior to the bulk insert and everything looks like.

This is a sporadic error and I've seen a few others that are similar so
it worries me that the objects are getting (slightly) corrupted between
the time I build them and when the bulk insert actually happens.

Has anyone seen something similar to this?

Thanks!

You mention you set up DataTable and so then where is the code?

chanmm

"dwelzel" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> While using SqlBulkCopy to load data into a SQL Server 2005 database,
> I've noticed an occasional exception that is saying one of the fields
> in my DataTable object contains a null value and this is failing the
> not null constraint on the table.
>
> When I set up the DataTable object prior to the bulk insert I simply
> set this field to an integer value, so it is never null in my code.
> I've even put in some validation code on the DataTable object that runs
> prior to the bulk insert and everything looks like.
>
> This is a sporadic error and I've seen a few others that are similar so
> it worries me that the objects are getting (slightly) corrupted between
> the time I build them and when the bulk insert actually happens.
>
> Has anyone seen something similar to this?
>
> Thanks!
>