package validation

SQLAGENT报错如上：

Message
Executed as user: 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: 00:15:15 Error: 2021-05-03 00:15:17.42 Code: 0xC0208452 Source: MARC(2061,2062) AUSDT is not null SAP_MARC [3398] Description: ADO NET Destination has failed to acquire the connection {BE3C7628-ED83-4C49-B34A-557C0651B61E}. The connection may have been corrupted. End Error Error: 2021-05-03 00:15:17.43 Code: 0xC0047017 Source: MARC(2061,2062) AUSDT is not null SSIS.Pipeline Description: component "SAP_MARC" (3398) failed validation and returned error code 0xC0208452. End Error Error: 2021-05-03 00:15:17.43 Code: 0xC004700C Source: MARC(2061,2062) AUSDT is not null SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2021-05-03 00:15:17.43 Code: 0xC0024107 Source: MARC(2061,2062) AUSDT is not null Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 00:15:15 Finished: 00:15:17 Elapsed: 1.81 seconds. The package execution failed. The step failed.

 

在SSISS中也无法正常执行

检查发现如下：

有如下两个错误

1、

 

2、数据库监听异常