我已经尝试了超过48小时,但没有成功。然后我创建了一个简单的包,其中包含一个FTP任务来下载文本文件。我使用“SQL Server部署”选项部署了该包。我在SSIS中看到了这个包,但是当我尝试使用以下命令从命令行运行时
dtexec /ser svrprod05 /sq Package
我遇到了错误
Microsoft (R) SQL Server Execute Package Utility
Version 9.00.3042.00 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 10:56:39 PM
Could not load package "Package" because of error 0xC0014062.
Description: The LoadFromSQLServer method has encountered OLE DB error code 0x80
004005 (Login timeout expired). The SQL statement that was issued has failed.
Source:
Started: 10:56:39 PM
Finished: 10:56:55 PM
Elapsed: 15.625 seconds
我尝试传递以下用户名和密码:
1. Local Administrator
2. Domain Administrator
3. Ent Administrator
4. SQL Server SA
我的最初目标在这里提到:这里。我不知道还有什么尝试的余地。