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!
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema