Activity overview
Latest activity by Girija
I think issue is resolved by granting view permission on tables.
It seems recently the application user was denied permissions to view table definition even though the user got read/write access on the tables. SQLBlkcopy seems to be trying to view the table definition and when it can't view it is throwing this exception error (misleading .. not properly described)...
Hope it might help anyone with similar issue. : [image] / comments
I think issue is resolved by granting view permission on tables.
It seems recently the application user was denied permissions to view table definition even though the user got read/write access on...
I am getting following error when I try to import excel sheet to SQL server.
I didn't use dot in the table name and it used to work fine before and I didn't make any changes to application. Microsoft article says problem arises if we fully qualified table name, but I am not using schema name with table name. http://support.microsoft.com/kb/944389
ex: string destTblName = "tbJobResponseIdsRaw";
SqlBulkCopy bulkCopy = new SqlBulkCopy(conn.ConnectionString);
bulkCopy.DestinationTableName = destTblName;
Error:
Failed to obtain column collation information for the destination table.
If the table is not in the current database the name must be qualified using the database name (e.g. [mydb]..[mytable](e.g. [mydb]..[mytable]);
this also applies to temporary-tables (e.g. #mytable would be specified as tempdb..#mytable). [image]
Any help on this is appreciated most. / comments
I am getting following error when I try to import excel sheet to SQL server.
I didn't use dot in the table name and it used to work fine before and I didn't make any changes to application. Microso...