I need to extract report from SQL stored procedure on monthly basis and send it by email.
Any idea on how to do it using UiPath?
I need to extract report from SQL stored procedure on monthly basis and send it by email.
Any idea on how to do it using UiPath?
Buddy @ealhariri
Welcome to uipath community
Kindly download and install the package in your manage packages in design menu
Uipath.Database.Activities
–after downloading we can use execute query and there you can mention the query you want to run for stored procedure and the output will be type datatable obtained from database…the only thing we need to provide is the user credentials and datasource of sql stored procedure
Kindly try this and let know buddy
Cheers @ealhariri