Time for a quick blog post on this error. This error has caught me out on more than one occasion, so much so that I’m writing this post now, grrrrr!
So what happens? You’re creating an SSIS Task that includes an OLEDB source. The OLEDB source calls a Stored Procedure and you’re passing in some parameters. So far so good:
Then you setup the Parameters (in my case just one as I’ve hard coded the second param to 1)
Great!, Let’s run it, and Error!
[OLE DB Source 1 ] Error: The SQL command requires a parameter named “@OrganizationName”, which is not found in the parameter mapping.
What! The parameter names in the call the proc and parameter settings match, hmm let’s take a close look:
So what happened? Being efficient and to avoid typo’s I cut and pasted the param name from the Stored Proc call to the Set Parameters Dialog, but picked up and trailing space along the way!
Trim the space and it will work fine. Why SSIS doesn’t trim the space I don’t know!