April 1, 2016

SSIS Task: The SQL command requires a parameter named “@Param”, which is not found in the parameter mapping.

Written by

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:

OLEDBStoredProc

Then you setup the Parameters (in my case just one as I’ve hard coded the second param to 1)

OLEDBParams

Great!, Let’s run it, and Error!

[OLE DB Source 1 [769]] 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:

OLEDBParamsWithSpace

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!

 

Category : Uncategorized

Comments

One Response

  1. David S says:

    THANKS! THAT WAS MY ISSUE! GRRR

Leave a Reply

Your email address will not be published. Required fields are marked *