Snowfun

导航

 

NSDZHSCMFP01\Administrator. 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'
;

 

posted on 2021-03-11 12:48  Snowfun  阅读(108)  评论(0编辑  收藏  举报