September 6, 2017 at 11:22 pm
Hi,
I have a SQL Task, running a query which EXEC a Proc. that proc returns a value: "
EXEC database.[dbo].[usp_getID] @BatchlD = @BatchlD OUTPUT
I want to get my BatchID back with the Result Set Tab, but I'm getting an error that:
[Execute SQL Task] Error: An error occurred while assigning a value to variable "": "Unable to find column in the result set.
September 7, 2017 at 12:24 am
If you are using OLEDB Connection, add an output parameter and change "ResultSet" property as "none"
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy