Data flow task error

  • 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

  • Check a couple things.

    -Are there any blank rows in your spreadsheet?

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

  • 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?


  • Hi,

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

    Thanks

  • 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.

  • 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.

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

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