Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Login timeout expired". Started: 8:00:03 AM Error: 08:00:18.85 Code: 0xC0202009 Source: DimAppealDecisionReason Connection manager "Facets OLE DB" Description: SSIS Error Code DTS_E_OLEDBERROR. 0 for 64-bit Copyright (C) Microsoft Corporation 2010. Microsoft (R) SQL Server Execute Package Utility Version. I have added the SQL AD account and made him SA on server B but still its failing. It runs fine for 3 to 4 hours and then fails. This Job runs every hour and failing randomly. I have one server "A" where all SSIS package are sitting and the job is making connection to different prod server, server B. One of my SSIS job is failing due to error below.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |