Geeks With Blogs
Soe Tun my attempt to solve common tech problems March 2009 Entries
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: GeeksWithBlogs.net | Join free