Data flow task error

Question

Post reply

Data flow task error

revanthdamarla

Grasshopper

Points: 21
More actions
August 4, 2011 at 12:42 am

#241185

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

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 1

Check a couple things.

-Are there any blank rows in your spreadsheet?

-Has the schema of the spreadsheet or the destination changed at all?

Phil Parkin SSC Guru Points: 247159 More actions · Answer 2

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?

revanthdamarla Grasshopper Points: 21 More actions · Answer 3

Hi,

Yes I have blank rows in the worksheets, but there are no schema changes.

Thanks

revanthdamarla Grasshopper Points: 21 More actions · Answer 4

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.

kramaswamy SSCoach Points: 18181 More actions · Answer 5

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.

Data flow task error

Cookies on SQLServerCentral