Can i use UI Path in executing sql files?

Help
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.

1 Like
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