October 31, 2013 at 9:34 am
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
October 31, 2013 at 2:06 pm
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.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply