How to call a procedure from MS sql server?

[rp2018]

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? 

[TRF · Accepted solution]

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

[fdenis]

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

[rp2018]

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.

[fdenis]

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.