Unknown error when inserting records into a MS SQL Server Table

abchakraborty · April 19, 2019, 5:30pm

Hi guys,
I am trying to insert the data from a datatable into a SQL server table and I am facing this weird error everytime:

I tried replacing all the " ’ " with " ‘’ " as suggested in a few solutions but this is giving me the same error.

Any solutions, please?

siddu509 · April 19, 2019, 6:00pm

Hi ,

Can you provide your SQL insert query?

Thanks,
Sid

abchakraborty · April 19, 2019, 6:02pm

Hello Sid,
I am using the Insert Activity of UIPATH Database activities. There is no specific SQL query for inserting the data

Topic		Replies	Views
Insert a datarow into sql table Studio studio , question , activities_panel	10	1656	March 9, 2021
How to insert a datatable into SQL Server database using Uipath database activities? Activities database	5	9093	November 18, 2021
Insert Database not working Help datatable , activities , studio	2	1639	July 5, 2019
Insert DataTable to SQl table, problem in insert activity Studio studio , question , variables_management	3	1637	June 22, 2021
Datatable from excel to ms-sql data table Activities datatable , excel , database , uiautomation , robot , activities , studio , question , ms-sql	2	586	April 18, 2023