Hello - still very new to UiPath. I’ve created a process to extract part of the body of an email from exchange. My next step is to insert that text into a table of a SQL database. I’m able to connect to the database, but i am not sure how to write the query to insert the variable i stored the extracted information in into the database/table. Here is what i have:
any help would be appreciated.
Did you configured the connection and do you have any sample quey?
Yes the connection is configured. I don’t have a sample query - not sure how to write one. It is something i am learning. I have the server name, the table name and field name that it needs to be written to.
This is the query i’ve created. I am getting an error message "invalid object name ‘cos_departureusers’ " Thoughts?
“INSERT INTO cos_departureusers(email,created)
VALUES (‘employeeEmail’,‘emailDate’)”
That tells us there is no table with that name, or it can’t find it.
“I have the server name, the table name and field name”
What about the database name?
Show us your connection setup. By the way, I don’t think you need the first “connect” activity.
Thanks you @postwick . I’ve removed the extra connect activity.
I realized that when i set up the connection, i didn’t include the database to which the SQL query is writing to. I fixed that, added it into the wizard setup and re-ran the process and it worked.
Thanks for the heads up.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.