Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ahmeds08
Aged Yak Warrior
737 Posts |
 Posted - 2014-09-12 : 06:07:58
|
| Hi,From last 2 days we are facing the below issue. The package has been working fine till yesterday.any help would be much appreciated.MessageExecuted as user: xxxx\xxxx. Microsoft (R) SQL Server Execute Package Utility Version 10.0.1600.22 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 1:36:06 AM Error: 2014-09-12 03:55:42.58 Code: 0xC0202009 Source: FactDecomponent Connection manager "DW Fosdick" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80004005 Description: "Timeout expired". End Error Error: 2014-09-12 03:55:44.88 Code: 0xC00291EC Source: Update DWActivity_S Execute SQL Task Description: Failed to acquire connection "DW Fosdick". Connection may not be configured correctly or you may not have the right permissions on this connection. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 1:36:06 AM Finished: 4:07:57 AM Elapsed: 9110.48 seconds. The package execution failed. The step failed.Javeed Ahmed |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-09-12 : 08:55:51
|
| This is your problem:Failed to acquire connection "DW Fosdick". Connection may not be configured correctly or you may not have the right permissions on this connectionCheck the configuration |
 |
|
|
|
|
|
SSIS Error