Package Run SQL Script -> Pass output to variable

Hellos,
let's assume I have a simple SQL script 

I can run this script in Package using SQL script but how do I pass the output to a variable ? 

These are the ones available from the package but none of them have the output 'suprisingly
'<Current Package Action Name>
<Action Comments>
<Result of Action Execution>
<On Success Execute>
<On Error Execute>
<Execution Status>
<Actual Execution Status>
<Sql Script>
<Sql Script Ignore Errors>
<Sql Script Error>
 

Please use set variable action

www.etl-tools.com/wiki/advanced-etl-proc...et-variables-action/

Major Brain Freeze moments , can I request for an example?

Is it SQL script or SQL lookup?

Default repository has some examples

Select
  '<ContactName>' As VariableName,ContactName As VariableValue
From Customers
where CustomerId='<CustomerId>'
union
Select
  '<ContactTitle>' As VariableName,ContactTitle As VariableValue
From Customers
where CustomerId='<CustomerId>'
union
Select
  '<Email>' As VariableName,Email As VariableValue
From Customers
where CustomerId='<CustomerId>'

Is it SQL script or SQL lookup

It can be any of them

Can you guide me which specific example? I looked at 0097 package number , I can understand that parameters can be passed , but once the sql script runs , how do I 'save the output' to another variable or even display the message?

I am basically trying to read from URL logger and then pass it to URL so I can pass the webhook forward

SO from here 
DECLARE @json NVarChar(max) select top 1 @json=text_field_02 from event_log where id =:sqlparamater;                               SELECT * FROM OpenJson(@json) WITH (   "mobile" VARCHAR(100) '$."{{mobile}}"',   "candidate_ID" VARCHAR(100) '$."{{candidate_id}}"',   "name" VARCHAR(100) '$."{{candidate_name}}"',   "position" VARCHAR(100) '$."{{position}}"',   "ctc" VARCHAR(100) '$."{{ctc}}"',   "join_date" VARCHAR(100) '$."{{join_date}}"',   "join_company" VARCHAR(100) '$."{{join_company}}"',   "referral_type" VARCHAR(100) '$."{{referral_type}}"',   "referral_by" VARCHAR(100) '$."{{referral_by}}"',   "offer_id" VARCHAR(100) '$."{{offer_id}}"' )

I want to simply do 

select text_field_02 from event_log where id =:sql_parameter';

AND

Pass the JSON object forward to HTTP Post , with minor modifications
Select