I was getting the following error
The SQL command requires a parameter named "@ParameterName", which is not found in the parameter mapping.
component "OLE DB Source" (1) failed the pre-execute phase and returned error code 0xC0207014.
in a SSIS Data Transfer Task that is using the following Stored Procedure EXEC code.
EXEC [dbo].[uspGetWhereUsedProductID] ?, ?