Home All Groups Group Topic Archive Search About

SqlBulkCopy class problem - Computed Columns

Author
7 Aug 2006 2:26 PM
Sri
While using SqlBulkCopy to insert data into a table which has a compupted
column it fails, throwing an error about not being able to insert data into a
computed column which is understandable, The only way you can insert data
into a table with a computed column is by not specifying the column in TSQL ,
now with the WriteToServer method is there an option we can set on the
SqlBulkCopy object to accomodate inserts for computed columns without
throwing errors?

Author
7 Aug 2006 3:42 PM
sri
apparantely editing column mapping solves this

Thanks


Show quote
"Sri" wrote:

> While using SqlBulkCopy to insert data into a table which has a compupted
> column it fails, throwing an error about not being able to insert data into a
> computed column which is understandable, The only way you can insert data
> into a table with a computed column is by not specifying the column in TSQL ,
> now with the WriteToServer method is there an option we can set on the
> SqlBulkCopy object to accomodate inserts for computed columns without
> throwing errors?
>
>

AddThis Social Bookmark Button