NSDZHSCMFP01Administrator. Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 32-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 12:26:07 Error: 2021-03-11 12:27:57.74 Code: 0xC002F210 Source: SAP_OSAL_OUT Execute SQL Task Description: Executing the query "INSERT INTO STG.SAP_OSAL_OUT(VBELN, POSNR, ETENR, ..." failed with the following error: "ERROR [HY000] [Oracle][ODBC][Ora]ORA-01843: 无效的月份 ". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. End Error DTExec: The package execution returned DTSER_FAILURE (1).
--INSERT INTO STG.SAP_OSAL_OUT(VBELN, POSNR, ETENR, EDATU, BMENG, YJHSL, WJHSL)
SELECT VBELN,
POSNR,
ETENR,EDATU,
--TO_DATE(SUBSTR(EDATU,1,4)||'-'||SUBSTR(EDATU,5,2)||'-'||SUBSTR(EDATU,7,2),'YYYY-MM-DD') AS EDATU,
BMENG,
YJHSL,
WJHSL
FROM SAPSR3.ZTFP_SO_SCHED@SAP_SEP
WHERE EDATU='00000000'
;
