This article troubleshoots an error that occurs when importing a file from the Data Warehouse Manager.
When a user imports a file from the Data Warehouse Manager, they receive the following error message:
"Syntax error: missing operand after 's' operator"
There is an apostrophe in import file data including column headers or apostrophe in the destination location where it is being imported.
Take out the apostrophe from the import file as well the destination location. Remove any apostrophe from either data or column header labels. If you are not able to delete the destination header labels on Data Warehouse manager then it needs to be removed from SQL server.
Data Warehouse Manager