Soe Tun

my attempt to solve common tech problems
posts - 10, comments - 173, trackbacks - 0

My Links

News

Twitter












Archives

Post Categories

Image Galleries

Thursday, March 05, 2009

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] ?, ?
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati
  •   Short Url: http://wblo.gs/XmZ
  • Posted On Thursday, March 05, 2009 4:20 PM | Feedback (86) | Filed Under [ SSIS ]

    Powered by: