Hello, it seems like I'm doing this right and most of the examples on the net I've found have it this way too, so I'm not sure what I'm donig wrong.
Ok, I have a execute SQL task in my SSIS package which should fire a stored procedure which has 2 parameters (@StartDate and @EndDate). The stored procedure runs fine using a exec statement: exec [dbo].[zKMHP_Proprietary] '10/1/2007', '10/31/2007'
If I take the above statement and put it in a Execute SQL task and hit parse, it parses successfully. Now if I replace my values with parameters this statement (exec [dbo].[zKMHP_Proprietary] ?, ?) I get the error: "The query failed to parse. Syntax error, permission violation, or other nonspecific error"
I do have my parameter mapping with these two as well in the execute sQL task, but at the very least it should parse correctly since according to everywhere I've looked on the net this is the way to feed parameters into a stored procedure from SSIS execute SQL task. What am I doing wrong?