Pentaho

 View Only

 Return Dataset using SQL Server Stored Procedure parameters

  • Pentaho
  • Kettle
  • Pentaho
  • Pentaho Data Integration PDI
Rob Burgess's profile image
Rob Burgess posted 04-11-2018 02:17

How do I execute a SQL Server stored procedure with parameters and return a dataset in a Kettle transformation?


#Pentaho
#PentahoDataIntegrationPDI
#Kettle
Rafael Valenzuela's profile image
Rafael Valenzuela

Hi ,

The only step is called DB procedure try this.

Rob Burgess's profile image
Rob Burgess

Thanks Rafael

I want to run the Store Procedure then write the returned dataset to Excel.

When I run the DB Procedure and click on the Preview data tab in Spoon I get three columns with no data. The first two column headings are called the IN parameters names  and last column is called result.

The transformation runs successfully in Spoon but doesn't appear to return any data.