Collation Conflict – SQL in Load Script

[wonkymeister]

Never had this issue before, on load of a large SQL script. Any ideas of a solution?

OleDb error

Connector reply error: ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Cannot resolve the collation conflict between “Latin1_General_CI_AS” and “SQL_Latin1_General_CP1_CI_AS” in the equal to operation.

[marcus_sommer · Accepted solution]

Maybe this is helpful: http://www.ashishblog.com/how-to-resolve-the-collation-conflict-and-how-to-check-collate-in-sql-serv... 

- Marcus

[wonkymeister]

sorted, cheers!