topic tMSSQLRow with tsql-Statement using Linked Server in Talend Studio

tMSSQLRow with tsql-Statement using Linked Server

Anonymous — Wed, 03 Jul 2013 17:03:18 GMT

Hello,
maybe someone can help:
in "Talend Open Studio for Data Integration" 5.3 i have problem with one tMSSQLRow-Object , which is connecting to mssql-database and using linked server within statement via function "openquery". e.g.:
"SELECT * FROM openquery(LINKED_SERVER,'select * FROM test.Table1')"
in talend-queryeditor i get correct result of this select-statement, so talend can run this statement.
But when i integrate this tMSSQLRow-Object in job-workflow, i always get only 1 row as result with values NULL.
additionally this linked server is a postgres-server in my case hehe
does anyone has ideas why this not work ? do you have same problems using function "openquery" in tsql-statements in talend ?
thank you very much for help. if i find solution too , i will post later here in this topic.
best regards, Carsten79

Re: tMSSQLRow with tsql-Statement using Linked Server

Anonymous — Wed, 03 Jul 2013 17:34:41 GMT

ok problem solved.
i should use "tMSSQLInput" instead of "tMSSQLRow" when goal is to process resultset.
topic can be closed.
best regards,
Carsten

Re: tMSSQLRow with tsql-Statement using Linked Server

Anonymous — Thu, 04 Jul 2013 03:33:46 GMT

Hi,
In addition, we usually use tDBInput to execute a select query, you have to use a tParseRecordSet after tDBRow to parse the record set if you use tDBRow to execute a select query.
You can see the component reference about tMysqlRow with scenario2 and scenario3.
Best regards
Sabrina

Re: tMSSQLRow with tsql-Statement using Linked Server

Anonymous — Mon, 08 Jul 2013 13:39:22 GMT

thank you very much for this tipp tParseRecordSet i will test and check out more.
best regards,
Carsten

Re: tMSSQLRow with tsql-Statement using Linked Server

Anonymous — Tue, 09 Jul 2013 04:46:50 GMT

Hi,
Feel free post your issue on forum.
Best regards
Sabrina