Export to Database Error

Support
1

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 5.6.1.12

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

2

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

3

I'm using the SQL Server connector for EM.

Dedicated SQL Pool in Azure.

image
image909×411 27.1 KB

4

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.

5

Thank you.

Does EM use an insert select or insert values statement?

6

You are welcome!

EM uses the insert values statement.

1 Like