I have a small problem.
After my process reads data from salesforce, I separate it and store it in some variables.
Now , I have to insert that data from variables into my database which is hosted locally.
I have connected to database and I am using Execute Non -Query activity, but getting error saying “Invalid Column Names”. I guess I am missing something so it is not able to insert.
Below is my Table structure in database.:
SELECT TOP (1000) [Name]
FROM [ANZ CMD Legal].[dbo].[ContactDetails]
Below is my query which I ma using in UiPath:
“INSERT Into [ANZ CMD Legal].[dbo].[ContactDetails] (Name, Country, Address, City, State, PostCode, Email) Values(Name, Country, Address, City, State, PostCode, Email)”
After running the code, I am getting the below error:
Can anyone please if I am missing anything or anything needs to be updated.