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

• sqlstud

  SSCrazy

  Points: 2527

  More actions

  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

• Phil Parkin

  SSC Guru

  Points: 247158

  More actions

  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.

  ---