I was running a Execute SQL Task to execute an SP and store the result of its two output parameters into global variables. But it did not seem to work when I used the ? (placeholder), even with and without the OUTPUT keyword. It also recognized the placeholders as input parameters. I found the solution at SQLDTS.com.
I used the ,"? OUTPUT" in several packages successfully. Then others it did not work at all. I have not researched it enough yet to determine when and why it works and other times it does not. Very odd behavior on that one.
-Mike Gercevich
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply