Skip to Content
0
Former Member
Feb 24, 2011 at 03:39 PM

COLLATE Error on Table Comparison

211 Views

Hi,

We have just upgraded to from version 11.7.3 to version 12.2.2 and we are getting this error when running the table comparison transform with sorted input:

"Expression type int is invalid for COLLATE clause. "

I asked our DBA to see what BODS was passing through at it is sending this:

WHERE ( "TCRdr_1"."VEHICLE_ID_NK" >= @P1 COLLATE Latin1_General_BIN)

Why is it using COLLATE, and more importantly is there anyway to control this?

The database is SQL Server 2005.

Thanks