topic Re: [resolved] tMSSQLrow not executing normal query in Talend Studio

[resolved] tMSSQLrow not executing normal query

Anonymous — Thu, 17 Oct 2013 11:55:19 GMT

Hi,
I have a query :
Select Column1,
column2,
column3,
column4
from TableName
I want the output of this query into a text file. Should I use tMSSQLrow for this? As per the reference guide, it is YES. But I am not able to achieve this. Please advise/suggest.
Keyur

Re: [resolved] tMSSQLrow not executing normal query

Anonymous — Fri, 18 Oct 2013 03:55:22 GMT

Hi,
Actually, for "Select" statement, you should use tMSSqlInput component.
tXXXRow component is usually used to any type of sql statement excepts select statement, we use txxxInput component to execute a select statement, if you use use tXXXRow to execute a select statement, it returns a record set, and you are required to use a tParseRecordSet component after tXXXRow to parse the record sets. You can find a demo job in this page.
Best regards
Sabrina

Re: [resolved] tMSSQLrow not executing normal query

Anonymous — Fri, 18 Oct 2013 05:19:33 GMT

Thank you very much!