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.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

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

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