August 4, 2011 at 12:42 am
Hi
I'm stuggling with this error from two days and I tried to google it but failed.
I'm not sure why the variable sheetname '101$' have some space in the error.
[Excel Source [1]] Error: An OLE DB error has occurred. Error code: 0x80004005.
[Excel Source [1]] Error: Opening a rowset for "'101$' " failed. Check that the object exists in the database.
[DTS.Pipeline] Error: "component "Excel Source" (1)" failed validation and returned validation status "VS_ISBROKEN".
Any help please.
Thanks
Rev
August 4, 2011 at 7:36 am
Check a couple things.
-Are there any blank rows in your spreadsheet?
-Has the schema of the spreadsheet or the destination changed at all?
August 4, 2011 at 7:41 am
Daniel Bowlin (8/4/2011)
Check a couple things.-Are there any blank rows in your spreadsheet?
-Has the schema of the spreadsheet or the destination changed at all?
Also, what is the worksheet name from which you are trying to import?
August 4, 2011 at 11:23 pm
Hi,
Yes I have blank rows in the worksheets, but there are no schema changes.
Thanks
August 4, 2011 at 11:27 pm
Hi Phil,
The workbook will start with worksheet 101 and so its the worksheet name. I'm using a variable in SSIS to pick up that starts with 101 and enumerates using Foor each loop container and For each ADO enumerator.
August 5, 2011 at 11:43 am
I think your problem is that SSIS is not finding the spreadsheet properly because you are using variables. Try putting Delay Validation to true, on the Excel Spreadsheet Connection Manager and on your data flow task.
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy