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