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;
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).
Any help on this is appreciated most.