Geeks With Blogs
Soe Tun my attempt to solve common tech problems SSIS SQL Server Integration Services
Execute SSIS Package from Stored Procedure with Parameters using DTEXEC Utility

How to execute a SSIS package from a Stored Procedure by passing in your own parameters for the SSIS package variables using DTEXEC utility.

Posted On Wednesday, February 24, 2010 6:25 PM

Mapping Stored Procedure Parameters in SSIS OLE DB Source Editor

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

Posted On Thursday, March 5, 2009 4:20 PM

Copyright © Soe Tun | Powered by: | Join free