How do I execute a SQL Server stored procedure with parameters and return a dataset in a Kettle transformation?
The only step is called DB procedure try this.
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.
Retrieving data ...