SSIS包创建Hresult：0x80004005描述：“登录超时过期”错误 [英] SSIS package creating Hresult: 0x80004005 Description: "Login timeout expired" error
问题描述
我有一个SSIS包，由一个每天运行两次的SQL作业执行。我最近通过删除其中的Select语句的where子句来更新SSIS包。现在结果有大约1800行相比，之前的650。当我在我的本地机器上执行新软件包一切运行正常。但是当我把它放在Prod服务器上，它不会运行，并给我Hresult：0x80004005说明：登录超时过期错误。
当未启用远程访问时，通常会抛出此错误。作业正在我的帐户下运行，所以权限不应该是一个问题。此外，该包运行没有问题之前，我只更改了一个where子句，使表大了一千行，所以我不应该有一个登录超时错误。
我知道它不是服务器上的剩余空间，因为如果我更改SSIS包的配置文件并将其导向生产数据库，一切工作正常。
任何人都知道什么可能会导致错误的原因，因为当我把旧的包放在旧的where子句时，问题？
这是日志条目：
以用户：服务执行。 ... sion 9.00.3042.00 for 32-bit版权所有（C）Microsoft Corporation 1984-2005。版权所有。开始：1:49:21错误：2011-08-04 13：50：12.28代码：0xC0202009源：Brd负载连接管理器DataBase说明：SSIS错误代码DTS_E_OLEDBERROR。发生OLE DB错误。错误代码：0x80004005。可以使用OLE DB记录。来源：Microsoft SQL Native ClientHresult：0x80004005描述：登录超时已过期。可以使用OLE DB记录。来源：Microsoft SQL Native ClientHresult：0x80004005描述：与服务器建立连接时发生错误。当连接到SQL Server 2005时，此失败可能是由于在默认设置下，SQL Server不会允许远程连接。可以使用OLE DB记录。来源：Microsoft SQL Native ClientHresult：0x80004005描述：TCP提供程序：连接att ...进程退出代码1.步骤失败。
我终于找到了问题。错误不是好的。
显然，Ole DB源有一个
该链接可能会导致OLE DB命令失败并导致该错误。得到我：
http： //social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/fab0e3bf-4adf-4f17-b9f6-7b7f9db6523c/
奇怪Bug，希望它会帮助其他人。
I have an SSIS package that is being executed by an SQL Job which runs twice a day. I recently updated the SSIS package by removing a where clause of a Select statement in it. Now the results have around 1800 rows compared tot he 650 of before. When I execute the new package on my local machine everything runs fine. But when I put it on the Prod server, it does not run and gives me Hresult: 0x80004005 Description: "Login timeout expired" error.
This error is usually thrown when remote access is not enabled but it is. The Job is running under my account, so the rights should not be a problem. Also, the package was running without problems before and I only changed a where clause that makes the Table larger by a thousand rows, so I should not have a login timeout error for that.
I know it is not the remaining space on the server because if I change the config file of the SSIS package and direct it the the production database, everything works fine.
Again, that problem is bugging me because when I put the old package with the old where clause, everything works fine.
Anyone has any idea what might be causing the problem?
Here is the Log entry:
Executed as user: Services. ...sion 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 1:49:21 PM Error: 2011-08-04 13:50:12.28 Code: 0xC0202009 Source: Brd Load Connection manager "DataBase" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Login timeout expired". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "TCP Provider: A connection att... Process Exit Code 1. The step failed.
I finally found the problem. The error was not the good one.
Apparently, Ole DB source have a bug that might make it crash and throw that error. I replaced the OLE DB destination with a OLE DB Command with the insert statement in it and it fixed it.
The link the got me there: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/fab0e3bf-4adf-4f17-b9f6-7b7f9db6523c/
Strange Bug, Hope it will help other people.
这篇关于SSIS包创建Hresult：0x80004005描述：“登录超时过期”错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
