Problems with getting return value in SQL task

• mark77

  Valued Member

  Points: 51

  More actions

  January 18, 2010 at 1:23 am

  #138121

  Hi;

  I've built a procedure that makes a log entry.

  It is executed with EXEC [MTA].[dbo].[P_INSERT_MTA_RUN] ?

  Where ? is an input variable with the package information.

  Now, the procedure then executes and it end with 'Return 1' or 'Return -1', depending on the result of my procedure.

  HOW do configure my SQL task correctly so that the -1 or 1 result end up in my SSIS Variable 'mtarun_result' ?

  Currently using: ResultSet; None

  Parameter Mapping: Only the input variable

  No Result Set. No Expressions.

  I'm at a loss. Thanks for the help!

• Erik Kutzler

  SSCarpal Tunnel

  Points: 4287

  More actions

  January 18, 2010 at 11:43 am

  #1105056

  In the General tab, set Result Set to "Single Row"

  In the Result Set tab, click the Add button to add a result and select your variable from the Variable Name drop-down box.

• sabyasm

  SSCarpal Tunnel

  Points: 4324

  More actions

  January 18, 2010 at 1:43 pm

  #1105120

  [font="Comic Sans MS"]

  Here is a quick and excellent reference :

  http://www.sqlis.com/post/The-Execute-SQL-Task.aspx

  [/font]

  [font="Comic Sans MS"]--
  Sabya[/font]

• mark77

  Valued Member

  Points: 51

  More actions

  January 19, 2010 at 1:53 am

  #1105269

  Thanks. That really helped.

  I also did not realize the extreme impotrance of using the 'return_value' as first defined variable.