I have connected talend with mssqlserver. I have a query to fetched data from mssqlserver.
When I execute a query on mssqlserver using Toad also directly on mssqlserver. I am able to see the result while when
while when I use this query on mssqlserver output component(tjdbcinput), it shows a column does not exist.
How to deal with this issue.
Note: I am able to guess schema using other queries.
Solved! Go to Solution.
I can't see your entire query, but I do not see a table either in the query or in the table field. This *could* be connected to the issue. It would be the first thing I would test anyway
Watch the recorded webinar!
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.
Test drive Talend's enterprise products.