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 2005 Forums  SSIS and Import/Export (2005)  SISS Job fails

Author  Topic  viejofeo Starting Member 1 Post Posted - 2014-02-25 : 10:43:03 Hello, Hi, I have hourly job that updates. I get this errors in the job. I can't figure out what's wrong and why it's failing. Please see error below. Thx in advance. Message Executed as user: NDS\svc_sqljob. ...ion 9.00.5000.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 4:00:00 PM Error: 2014-02-24 16:00:01.37 Code: 0xC0202009 Source: Import REO Boarding excel file into REO_IN_BOARDING table Excel Source [1] Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. End Error Error: 2014-02-24 16:00:01.37 Code: 0xC02020E8 Source: Import REO Boarding excel file into REO_IN_BOARDING table Excel Source [1] Description: Opening a rowset for "REO_Boarding$" failed. Check that the object exists in the database. End Error Error: 2014-02-24 16:00:01.41 Code: 0xC004706B Source: Import REO Boarding excel file into REO_IN_BOARDING table DTS.Pipeline Description: "component "Excel Source" (1)" failed validation and returned validation status "VS_ISBROKEN". End Error Error: 2014-02-24 16:00:01.41 Code: 0xC00470... The package execution fa... The step failed. Bobby Rivera