Output Parameters with Global Variables

  • 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.

    Gogula

  • 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