SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 SISS Job fails
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

viejofeo
Starting Member

USA
1 Posts

Posted - 02/25/2014 :  10:43:03  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.25 seconds. Powered By: Snitz Forums 2000