Bulk Update - Bulk update: Incorrect syntax near the keyword 'INTO'

Help Activities
, ,
1

Hi Community,
In Bulk update: Activity I’m Facing this Error Incorrect syntax near the keyword ‘INTO’.
Microsoft.Data.SqlClient.SqlException: Incorrect syntax near the keyword ‘INTO’. at UiPath.Database.Activities.BulkUpdate.HandleException(Exception ex, Boolean continueOnError)
at UiPath.Database.Activities.BulkUpdate.ExecuteAsync(AsyncCodeActivityContext context, CancellationToken cancellationToken)
at UiPath.Database.Activities.AsyncTaskCodeActivity.EndExecute(AsyncCodeActivityContext context, IAsyncResult result)
at System.Activities.AsyncCodeActivity.CompleteAsyncCodeActivityData.CompleteAsyncCodeActivityWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)
The image shows a Bulk update configuration interface where connection settings, table name, data table identifier, and column used for matching rows are specified. (Captioned by AI)

2

@sayali.p,

The activity configuration seems correct. Try updating the Database activities package to latest possible version and try again.

Thanks,
Ashok :slight_smile:

3

Make sure you are using the non-preview version of the dependency.

Hope it helps!