I use connect function to database, and want the output in excel
You can write output from query after connect activity to excel using ‘Write range’ activity.
Also please change the tags of this topic, its more of a question than feedback. Right tags helps your topic gain right traction:)
After connect activity use Execute NonQuery activity and write your sql expression like Select * from TableName, In the properties create an output variable which will be a Datatable
Then use Write Range activity and pass the Datatable variable
You can see the output in Excel
Hope this may help you