How to send data uipath to microsoft sql server management studio

Help Studio
1

I want to send send workflow name to the database
how i get workflow name i am using this activity
A

and store in variable like you can see in picture

b
b547×527 8.88 KB

so new i want to store this data in database can someone help me to create a logic

like you can see in picture workflow name is main
p
now i want to store this workflow name in database in process column can someone help me to create this logic
d

2

@imumeriqbal

You need to use first have the drivers installed to work with database activities and download the UiPath.database.activities as well…

Once this is done use connect activity to connect to the db

And then use execute non query to run the insert statement which would contain the data from the job info variable

The insert statement syntax is same as any sql insert statement

https://docs.uipath.com/activities/docs/execute-non-query

Cheers

3

I got this error

n
n1907×616 8.1 KB

n1

Main.xaml (11.2 KB)

d

4

@imumeriqbal

it is expecting 4 values …you are only giving one…that si the reason it is failing

you have to give id,process,datetime,comment all 4

cheers

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.