Thanks that was the issue. When adding the TMSSqlInput auto generated the SQL query with database context variables concatenated in the query. I removed all the context variables and had a single SQL query string and that worked.
This is the query that gets auto generated (which was causing the issue). What is the proper way to concatenate the query with the context variables. Btw the context variable context.netZcore_Schema is defined.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Find out about Talend's 2019 Summer release
Talend continues to revolutionize how businesses leverage speed and manage scale
Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend