Error Code | 7 |
Error Message | Execution ended in error--> Error preparing map for execution: Error 25507 opening target 'ODBC 3.5 Mass Insert': Exec SQL failed: SQL Statement <CREATE TABLE '<TableName>' ('<ColumnName1>' <DataType>, '<ColumnName2>' <DataType>, '<ColumnName3>' <DataType>)>. |
Description | This error message is displayed for ODBC 3.5 Mass Insert target connector, when the create or drop table syntax during execution is incorrect. |
Cause/Solution | Cause: Single quote has been used as the value of IdentifierQuotes property and this results in incorrect create or drop table syntax during execution. Solution: Change the value of IdentifierQuotes property: 1. Click the Target tab. 2. Change the IdentifierQuotes connector property value from ' (single quote) to None, Default or " (double quotes). 3. Save and Run the Map. |
Related Information |