How to execute a SSIS package from a Stored Procedure by passing in your own parameters for the SSIS package variables using DTEXEC utility.
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] ?, ?