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.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 SSIS Error

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.

Message
Executed 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 connection

Check the configuration
Go to Top of Page
   

- Advertisement -