Skip to content Skip to sidebar Skip to footer

Sqlbulkcopy Failed To Obtain Column Collation Information For The Destination Table

I am getting this error when I try to write rows to a table via SqlBulkCopy and a DataTable object. Before going any further, let me say that I am aware of the Microsoft KB articl

Solution 1:

I have no idea why this would make a difference, but when I gave the account used to connect to the database the right to Grant the View Definition permission - under Database Properties / Permissions - the error went away.


Post a Comment for "Sqlbulkcopy Failed To Obtain Column Collation Information For The Destination Table"