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