The way I do it:

Create a Transform Data Task.

Define you stored procedures as lookup query.

In de query designer use the following syntax: spname ?,?,?

For the package it does't matter if...