Error : Opening a rowset for "Sheet$" failed. Check that the object exists in the database.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » Error : Opening a rowset for "Sheet$" failed....

Error : Opening a rowset for "Sheet$" failed. Check that the object exists in the database.

Rate Topic

Display Mode

Topic Options

Author

Message

sqlstud

Posted Wednesday, October 10, 2012 10:53 PM

SSC Journeyman

Group: General Forum Members
Last Login: Tuesday, March 12, 2013 3:57 AM
Points: 93, Visits: 237

Hi,

i am trying to load the data from excel sheet using For each loop container in ssis 2005.

But it gave me the below error:

Error: Opening a rowset for "Sheet1$" failed. Check that the object exists in the database.

[DTS.Pipeline] Error: "component "failed validation and returned validation status "VS_ISBROKEN".

Error: There were errors during task validation.

Could you please let me know the solution

Regards
Sqlstud

Post #1371209

Phil Parkin

Posted Thursday, October 11, 2012 1:06 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 9:20 AM
Points: 4,242, Visits: 9,494

I would guess that the worksheet is called something other than 'sheet1'. Find out what that is and change the connection info.

____________________________________________________________________________________________

Help us to help you. For better, quicker and more focused answers to your questions, consider following the advice in this link:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

If you are asking for help and your post does not contain a question, you should expect responses which do not contain any answers. Put a question mark in there somewhere - it's not rocket science.

Post #1371234

« Prev Topic | Next Topic »

Permissions