I have an MS SQL query that does not contain any Escape characters. However I receive this error message when I try to Guess Schema. Please advise.
SELECT distinct C.ClientId, C.ClientName FROM client c
WHERE C.ClientId > 0 AND C.Status = 0
and c.[Language] in (1033)
Could you please check your "Code" tab in your job to see if there will be your compile error highlighted in red line?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables