Package Run SQL Script -> Pass output to variable

To make life of all our customers easier we have added an example to our wiki

Here is the link

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

I hope you will find it useful

admin wrote:

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

 

Thank you for taking time to put this together , will test this and update you. 

HI ,
It's working ! 

For others , who will look at this post , please see how to use parameters inside the query as an example. IN screenshot, in query we are defining the parameter we will use <id>
select '<json_variable>' as variable_name, text_field_02 as variable_value from event_log where id ='<id>'



Notice 2XSet Variables? 1st one is where we pass the <id> value 

Hellos,
When I run the script via command line  , package works but I get below message

Information     04-08-2024 16:03:38     Using Following Sql: SELECT '<json_variable>' AS variable_name,  text_field_02 AS variable_value FROM event_log WHERE id = '561b2923-dcea-4e61-8156-ca02eb659ab6'; Error   04-08-2024 16:03:38     Calculation Failed:

{   "{{mobile}}": "0912563",   "{{candidate_id}}": "372",   "{{candidate_name}}": "Tanvi Musk",   "{{candidate_position}}": "HR manager",   "{{candidate_ctc}}": "540000",   "{{join_date}}": "2024-05-08",   "{{candidate_address}}": "shivaji chowk aavas bhuvan ghatkopar east",   "{{join_company}}": "Firkee Accessories Pvt Ltd",   "{{appointment_id}}": "00008",   "{{company_address}}": "A1 Unit 148, First Floor, Shah",   "{{company_logo}}": "firkee_logo.png",   "{{letter_type}}": "04-Appointment Letter" }

Error   04-08-2024 16:03:38     Following Error happened: Expression expected but '"' found
 

Perhaps json is not valid?

Or you have to adapt the script. 

admin wrote:

Perhaps json is not valid?
 

that's the first thing I thought ,I verified the json , it's completely fine. 

I tried to check the validity of the JSON
I also tried removing the {{ }} from the JSONs variable name  


Again everything works , but I can't understand the error