SQL Data Generator 2

Generating data in improperly-named column causes System.InvalidOperationException

When generating data for a table whose name contains a dot (.), the following exception message will be displayed and data generation will stop:

System.InvalidOperationException: Failed to obtain column collation information for the destination table.

The cause of the problem is that the Microsoft ADO .NET SqlClient's bulk insert functionality contains a bug that will cause a collation error if there is a dot in the table name. For instance, a table called [dbo].[My.Table] would cause this error to occur.

There is no known workaround for this error at this time except to rename the table or exclude it from data generation.

For more information, see: http://support.microsoft.com/kb/944389 (Microsoft documentation).


Didn't find what you were looking for?