Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Migrated to Sql 2014 from 2008 R2 and upgraded to 2.20.6 from 2.17.7. Getting 'True' checkbox error.


Before the massive upgrade I didn't get this error. Still works on the old Server.

However, on the new one, when I run this script;

select id,
'True' as CheckBox__c,
CAST('' as NVARCHAR(512)) as error
INTO CustomObject__c_CheckBox
from Salesforce...CustomObject__c
where CheckBox__c = 'false'

after that runs I run;

exec SF_BulkOps 'update','salesforce','CustomObject__c_CheckBox'

But I get this error?

OLE DB provider "DBAmp.DBAmp" for linked server "salesforce" returned message "Error 13005 : Error translating SQL statement: line 1:125: unexpected token: 'True'".
Msg 7320, Level 16, State 2, Line 21
Cannot execute the query "SELECT "Tbl1005"."CheckBox__c" "Col1009","Tbl1005"."Id" "Col1010","Tbl1005"."Job_Complete__c" "Col1011",'True' "Expr1006",'' "Expr1007" FROM "CustomObject__c" "Tbl1005" WHERE "Tbl1005"."CheckBox__c"='false' against OLE DB provider "DBAmp.DBAmp" for linked server "salesforce".
1 person has
this problem