SQL Task won't return a value

• hoseam

  SSCertifiable

  Points: 5533

  More actions

  September 6, 2017 at 11:22 pm

  #325222

  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.

• VENUGOPAL.RR

  Ten Centuries

  Points: 1395

  More actions

  September 7, 2017 at 12:24 am

  #1958483

  If you are using OLEDB Connection, add an output parameter and change "ResultSet" property as "none"