1888839 - DBS-070404: |<DataFlow>SQL submitted to ODBC data source <DataSource> resulted in error <[Sybase][ODBC Driver][Sybase IQ]Syntax error near - SAP Data Services 14.2.0.301

When updating or deleting data from a Sybase IQ target database during a Bulk Load job run the following error message is generated:

14.2) 07-03-13 13:20:33 (R) (65240:64432) DBS-070404: |Data flow DF_SCD2
            SQL submitted to ODBC data source <SPME154> resulted in error <[Sybase][ODBC Driver][Sybase IQ]Syntax error near '_s' on line
            1>. The SQL submitted is <DECLARE LOCAL TEMPORARY TABLE "TableComparison_SCD2"_s (DI_SEQUENCE_NUMBER INTEGER , "ID" DECIMAL(28,
            0) , "NAME" VARCHAR (25) , "ADDRESS" VARCHAR (50) , "SID" DECIMAL(28, 0) , "CurrentValue" INTEGER , "ValidFrom" TIMESTAMP ,
            "ValidTo" TIMESTAMP  ) ON COMMIT PRESERVE ROWS>.

• SAP Data Services 14.2.0.301
• Sybase IQ 15.4

KBA , EIM-DS-EXE , Job Execution , Bug Filed