topic Re: How to call a procedure from MS sql server? in Talend Studio

How to call a procedure from MS sql server?

rp2018 — Thu, 20 Sep 2018 14:03:37 GMT

I have a procedure as follow

create procedure up_names as

begin

select firstname,middlename,lastname from employee

end

How do you execute this procedure and output the records? No parameters to pass.

I've setup a job with tMSSqlsp-->tParseRecordset--->tLogRow

How do you configure tMSSqlsp and tParseRecordset?

Re: How to call a procedure from MS sql server?

TRF — Thu, 20 Sep 2018 14:07:49 GMT

See this page https://help.talend.com/reader/iYcvdknuprDzYycT3WRU8w/Y4ldtMoTiuC0d9L2HNRqzw

Re: How to call a procedure from MS sql server?

fdenis — Thu, 20 Sep 2018 14:10:11 GMT

add select query at the end of your proc. you can retrieve this dataset on the output of tMssqlP.

Re: How to call a procedure from MS sql server?

rp2018 — Thu, 20 Sep 2018 15:18:34 GMT

I've followed the link and was able to execute the procedure and get data. Anyway to have the information fill automatically in tParseRecordSet when we click on Edit Schema. I end up typing each return columns and it doesn't have an option like Guess Schema.

Re: How to call a procedure from MS sql server?

fdenis — Thu, 20 Sep 2018 15:25:27 GMT

Guess Schema is allowed when you can get data schema from system tables.
here you did not have system table so you cannot get schema.