Data Warehouse Manager: Error when importing into Data Warehouse Manager

Summary:

The user is getting an error message when importing file from Data Warehouse Manager.

Symptoms:

Syntax error: missing operand after 's' operator

Cause:

There is an apostrophe in import file data including column headers or apostrophe in the destination location where it is being imported.

Resolution:

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.

Properties:

Applies to: Data Warehouse  4.x