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.