In a Microsoft .NET Framework 2.0 application, you use the SqlBulkCopy
class to copy data from a System.Data.DataTable to a table in Microsoft SQL Server. If the table
name contains a dot character (.),
you receive the following error message:
System.InvalidOperationException was unhandled
Message="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)."
This problem is caused by an issue in the System.Data.dll
To work around this problem, avoid
in table names.
If you have to use a
dot character (.) in a table name,
use the dot character (.)
as part of the SQL naming convention. For example, use a table name that
has confirmed that this is a problem in the Microsoft products that are listed
in the "Applies to" section.