Error Code | 8 |
Error Message | From InsertRecord: SQL state 42S02, message:[Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name <TableName>.. Check log for more details. |
Description | This error may be displayed when insert operation fails for a new table. This error is usually displayed for multimode connectors like Actian X, Vector, Actian Zen, SQL SERVER 2019, and ODBC3.5. |
Cause/Solution | Cause: The Table Name has not been specified using the Advanced Map View option. Solution: Add “Transformation started” map event from configuration tab: 1. Open the transformation. 2. Click the Configuration tab. 3. Go to Map events section. 4. Add transformation started map event with Drop/Create Table operation. |
Related Information |