How to read the rows returned from the stored procedure with the tDBSP component?

[Anonymous]

Hi, I'm a beginner with the Talend Open Studio for Data Integration tool, version 7.0.1.

I have a stored procedure developed in SQL Server that returns n rows.

How to read the rows returned from the stored procedure with the tDBSP component?

Thanks, Ana

[Anonymous]

You can refer to the following images

Here is the shemas

Here is the job

I hope this will help

[Anonymous]

Thanks @dgm01 ,

In my case I am using the Microsoft SQL Server database.

When I choose the Microsoft SQL Server Database the parameters change.

Do you have an example with SQL Server and the stored procedure with input parameters?

I tried to implement following your example, but when I inform "Type" = OUT, the component understands that it is a return parameter of the procedure.

Regards,

Ana

[Anonymous · Accepted solution]

Hi,

I was able to follow the example of this link:

https://help.talend.com/reader/V2ZZaxdS78HmPacuPcEwkw/_l7WigLwFFyngax3SVApNA

Thanks,

Ana