Can i use UI Path in executing sql files?


#1

Can i use UI Path in executing sql files ?


#2

Hi @paolomondelo,

Yes of course you can, have a look here

Do not forget to add Database Activities package

Thanks,
Prankur


#3

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.


#4

I’m looking into this myself.


#5

Hi,
This type of expression is doing the trick

File.ReadAllText("myfile.sql")

Read Text File activity should work as well.

Cheers