A sproc as an OLE DB Source
Remember when you use a Stored Procedure as the OLE DB Source that you need to turn off the ‘x many rows affected’ statement at the end.
Do this by including in the CREATE PROCEDURE script the statement:
SET NOCOUNT ON
Also, ensure that you make the full call to the procedure:
EXEC spStoredProcedure @myString = ?, @myInteger = ?
This makes parameter mapping much easier, however, don’t expect to be able to preview the data… this only seems to work at run-time.
