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.
| Author |
Topic |
|
jbphoenix
Yak Posting Veteran
68 Posts |
 Posted - 2009-10-15 : 16:34:44
|
| I have an ole db source that runs a sql statement, then a data conversion for 1 field, then an excel source. The first time I ran the package it worked. I then tried to run it again and it failed with this - Error: 0xC0202009 at Data Flow Task, Excel Destination 5 [2783]: An OLE DB error has occurred. Error code: 0x80004005.Error: 0xC02020E8 at Data Flow Task, Excel Destination 5 [2783]: Opening a rowset for "TEST$" failed. Check that the object exists in the database.Error: 0xC004706B at Data Flow Task, DTS.Pipeline: "component "Excel Destination 5" (2783)" failed validation and returned validation status "VS_ISBROKEN".Error: 0xC004700C at Data Flow Task, DTS.Pipeline: One or more component failed validation.Error: 0xC0024107 at Data Flow Task: There were errors during task validation.Now, if i create a new tab on the excel sheet and set that up to the be source it works, but only 1 time. I have data going to other tabs following a similiar process and they all work. So I don't understand what's wrong. Any ideas?Thanks |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-10-16 : 07:32:00
|
| Should the Excel sheet "TEST$" exists always?Is there a step/process that removes/renames/protects it?Check for all references to this sheet. |
 |
|
|
|
|
|
Excel destination errors