Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.

Execute list of Insert SQL from a file

Highlighted
5 - Atom

Currently i have a file with 100+ insert statement which we receive from external team. Each insert statement will load data into same table in same database. Please let me know how can i can execute all the insert statement 

Highlighted
15 - Aurora

If you can solve this problem for 1 Insert statement using, say, an Output Data tool, you can wrap this Output Data tool in a batch macro and get it to execute the list of Insert statements one by one.

Highlighted
7 - Meteor

Hello @raghutv85 ,

 

Connect the input file to a dynamic input tool. Dynamic input tool will execute the insert statement and update the database.

 

Regards,

Naveen

Labels