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.
Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend
Test drive Talend's enterprise products.