Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Login TImeout Expired Error in SSIS Expand / Collapse
Author
Message
Posted Thursday, October 31, 2013 9:34 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 30, 2014 10:16 AM
Points: 2, Visits: 20
I have some SSIS packages scheduled as SQL Server agent job running every hour. These packages intermittently throws following error:

Microsoft (R) SQL Server Execute Package Utility Version 10.50.4000.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 6:30:00 AM Error: 2013-10-30 06:31:16.18 Code: 0xC0202009 Source: Pkg_Fact_Load Connection manager "TEST" 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 Server Native Client 10.0" Hresult: 0x80004005 Description: "Login timeout expired". An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Unable to complete login process due to delay in login response". An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "TCP Provider: Timeout error [258]. ". End Error Error: 2013-10-30 06:31:16.18

Could someone suggest some fix to this issue?

FYI- I am using XML Configuration file in these jobs.

Regards,

Mayank
Post #1510265
Posted Thursday, October 31, 2013 2:06 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, June 27, 2014 2:05 PM
Points: 300, Visits: 810
If they have run successfully before, it seems to me like intermittent connection failure due to possible network latency?

If they have not run successfully before, it's a permissions issue.
Post #1510417
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse