SSIS报错求大神赐教
0
hi,大神
我在操作ssis时，遇到个报错，一直解决不了，跪求大神帮忙答疑。万分感谢。
用测试环境覆盖到正式环境中，运行job.报了以下错误：
Executed as user: NESTLE\CNSHMD0006_SQLSvc. Microsoft (R) SQL Server Execute Package Utility Version 11.0.6020.0 for 32-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 5:59:48 PM Error: 2017-09-18 17:59:51.76 Code: 0xC0016016 Source: BI_Wyeth_EDW_Dim Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. End Error Error: 2017-09-18 17:59:51.96 Code: 0xC0016016 Source: BI_Wyeth_EDW_Dim Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. End Error Error: 2017-09-18 17:59:52.13 Code: 0xC0016016 Source: BI_Wyeth_EDW_Dim Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. End Error Error: 2017-09-18 17:59:54.17 Code: 0xC001000E Source: BI_Wyeth_EDW_Dim Description: The connection "Excel Connection Manager 1" is not found. This error is thrown by Connections collection when the specific connection element is not found. End Error Error: 2017-09-18 17:59:59.62 Code: 0xC004706B Source: DET_d_non_primary_distributor SSIS.Pipeline Description: "OLE_d_non_primary_distributor" failed validation and returned validation status "VS_NEEDSNEWMETADATA". End Error Error: 2017-09-18 17:59:59.62 Code: 0xC004700C Source: DET_d_non_primary_distributor SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2017-09-18 17:59:59.62 Code: 0xC0024107 Source: DET_d_non_primary_distributor Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 5:59:48 PM Finished: 5:59:59 PM Elapsed: 11.856 seconds. The package execution failed. The step failed.
我在操作ssis时，遇到个报错，一直解决不了，跪求大神帮忙答疑。万分感谢。
用测试环境覆盖到正式环境中，运行job.报了以下错误：
Executed as user: NESTLE\CNSHMD0006_SQLSvc. Microsoft (R) SQL Server Execute Package Utility Version 11.0.6020.0 for 32-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 5:59:48 PM Error: 2017-09-18 17:59:51.76 Code: 0xC0016016 Source: BI_Wyeth_EDW_Dim Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. End Error Error: 2017-09-18 17:59:51.96 Code: 0xC0016016 Source: BI_Wyeth_EDW_Dim Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. End Error Error: 2017-09-18 17:59:52.13 Code: 0xC0016016 Source: BI_Wyeth_EDW_Dim Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. End Error Error: 2017-09-18 17:59:54.17 Code: 0xC001000E Source: BI_Wyeth_EDW_Dim Description: The connection "Excel Connection Manager 1" is not found. This error is thrown by Connections collection when the specific connection element is not found. End Error Error: 2017-09-18 17:59:59.62 Code: 0xC004706B Source: DET_d_non_primary_distributor SSIS.Pipeline Description: "OLE_d_non_primary_distributor" failed validation and returned validation status "VS_NEEDSNEWMETADATA". End Error Error: 2017-09-18 17:59:59.62 Code: 0xC004700C Source: DET_d_non_primary_distributor SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2017-09-18 17:59:59.62 Code: 0xC0024107 Source: DET_d_non_primary_distributor Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 5:59:48 PM Finished: 5:59:59 PM Elapsed: 11.856 seconds. The package execution failed. The step failed.
没有找到相关结果
重要提示：提问者不能发表回复，可以通过评论与回答者沟通，沟通后可以通过编辑功能完善问题描述，以便后续其他人能够更容易理解问题.
0 个回复