Package Run SQL Script -> Show Output as Message

More
1 year 9 months ago #24383 by prashant
Hellos,
I have a simple SQL script which is working fine when running as query ,see output 
 

Script is 
SELECT '<json_variable>' AS variable_name,        text_field_02 AS variable_value FROM event_log WHERE id = '00433034-b7f6-44c1-9ec4-91012578a4a0';

I tried a package with two items , Run Script , Show message, but I am not getting the expected output (which should be the json object)
 
 
The following user(s) said Thank You: admin

Please Log in or Create an account to join the conversation.

More
1 year 9 months ago #24384 by admin
The easiest way to find 'magically missing' variable is to click on the variables tab and perform value search

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
1 year 9 months ago #24385 by prashant
I am not able to understand , can I get a working package as example ? 

The problem is I am not able to use SQL script and get the output of the script 
 

Please Log in or Create an account to join the conversation.

More
1 year 9 months ago #24386 by prashant
I assume you mean this ? or something else?
 

Please Log in or Create an account to join the conversation.

More
1 year 9 months ago #24387 by admin
I mean this one

Please run the package first
 

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
1 year 9 months ago #24390 by prashant
GOT IT !!!
Thank you , didn't know this window exists !!

Please Log in or Create an account to join the conversation.

Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Read more
Marketing
Set of techniques which have for object the commercial strategy and in particular the market study.
Google
Accept
Decline
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline
Google Analytics
Accept
Decline
Functional
Tools used to give you more features when navigating on the website, this can include social sharing.
Advertisement
If you accept, the ads on the page will be adapted to your preferences.
Google Ad
Accept
Decline
Save