Soe Tun

my attempt to solve common tech problems

  Home  |   Contact  |   Syndication    |   Login
  14 Posts | 0 Stories | 217 Comments | 0 Trackbacks


Article Categories



SQL Server Integration Services

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] ?, ?