|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SqlBulkCopy class problem - Computed ColumnsWhile 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? 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? > > |
|||||||||||||||||||||||