Can i use UI Path in executing sql files ?
Yes of course you can, have a look here
Do not forget to add Database Activities package
I mean like can i just simply call a file called Test123.sql and execute it? I knpw the execute query function of ui path simply executes an sql statement and not the sql file itself.
I’m looking into this myself.
This type of expression is doing the trick
Read Text File activity should work as well.