Post reply

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

  • October 10, 2012 at 10:53 pm

    #263173

    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

  • October 11, 2012 at 1:06 am

    #1547900

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

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

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

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