July 10, 2008 at 7:27 am
I am testing a package that uses variables to assign parameters to a stored procedure. I assign values to these variables manually for testing purposes and when I run the package I get an error saying there is no values for the parameters.
Please help.
July 10, 2008 at 7:42 am
Parameters are a bit of a minefield in my experience.
How you specify them depends on the connection type
e.g. OLE DB connection requires the symbol '?' and parameter names should be numeric 0, 1, 2 etc. The error messages for getting it even slightly wrong are not always helpful.
Try this page - it helped me to sort out my parameters.
July 10, 2008 at 8:30 am
I resolved it. Turns out you must name the parameters in the Extract step to exactly what they are named in the stored procedure.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply