Export to Database Error

I'm trying to Export to database, SQL database, and I get this error if I try to export more than 1 record at a time. Currently on version

Error: Export of batch with rows #1-10 failed with the following error: Parse error at line: 1, column: 635: Incorrect syntax near ','.

What database are you exporting to, and which connector are you using - native or ODBC?

I'm using the SQL Server connector for EM.

Dedicated SQL Pool in Azure.

It seems that Azure Synapse Analytics doesn't support the insertion of several rows with a single INSERT command. So the "Export to database" action will have to export rows one by one.

Thank you.

Does EM use an insert select or insert values statement?

You are welcome!

EM uses the insert values statement.

1 Like