问题描述
我在ssis运行软件包时经常遇到错误。
Microsoft(R )SQL Server执行包实用程序 版本11.0.2100.60适用于64位 版权所有(C)Microsoft Corporation。保留所有权利。  入门: 凌晨2:00:00 错误:2019-05-09 02:00:03.66   代码:
0xC0024104   来源:刷新Microsoft Excel任务   说明:任务上的Execute方法返回错误代码0x8000401A(由于以下错误,检索CLSID为{00024500-0000-0000-C000-000000000046}
的组件的COM类工厂失败:8000401a服务器进程无法启动,因为配置的身份不正确。请检查用户名和密码。(HRESULT异常:0x8000401A)。)。 Execute方法必须成功,并使用"out"指示结果
。参数 结束错误 DTExec:包执行返回DTSER_FAILURE(1)。 入门: 凌晨2:00:00 完成时间:凌晨2:00:03 经过:  2.87秒。 包执行失败。
步骤失败。
任何人都可以帮我解决这个问题吗?
Hi ,
I often get the error when I run the package in ssis.
Microsoft (R) SQL Server Execute Package Utility Version 11.0.2100.60 for 64-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 2:00:00 AM Error: 2019-05-09 02:00:03.66 Code: 0xC0024104 Source: Refresh Microsoft Excel Task Description: The Execute method on the task returned error code 0x8000401A (Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 8000401a The server process could not be started because the configured identity is incorrect. Check the username and password. (Exception from HRESULT: 0x8000401A).). The Execute method must succeed, and indicate the result using an "out" parameter. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 2:00:00 AM Finished: 2:00:03 AM Elapsed: 2.87 seconds. The package execution failed. The step failed.
can anyone help me in solving this issue?
这篇关于错误0x8000401A的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!