How to run sql file from uipath

Help Something Else
1

Can anyone help me to run the sql file from uipath studio.

Using “Execute Query” activity, I am able to run only one query. I am already having all my queries in sql file.

2

@Visalakshi_Jayabalan

You can directly pass the file path and try if it is working

OR

Use Read Text file activity, Pass the file path of the .sql file and create a variable, after that pass this variable to Execute Query activity

Hope this may help you

Thanks

3

Hi

If possible have those sql queries as a procedure or function and
then we can run them with with EXECUTE QUERY activity where pass the stored procedure name and mention the type property as Stored procedure

Cheers @Visalakshi_Jayabalan

4

Thanks.let me try

5

Sure thanks

1 Like
6

Let us know if you are facing the issue

@Visalakshi_Jayabalan