Post reply

OLE DB Excel connection Manager problem

  • March 19, 2012 at 12:02 am

    #252960

    I have an SSIS package which was working fine until couple of weeks ago....Recently when i try to run package it fails with the following error message

    Opening a rowset for header failed..Check that the object exists in the database

    Component Excel source(1) failed validation and returned validation status "VS_ISBROKEN"

    Actually header excel sheet exists but not sure why the Excel Connection Manager cannot open Header excel sheet

    Any suggestions??

    Thanks in advance

  • March 19, 2012 at 1:13 am

    #1460986

    So the sheet called Header exists in your Excel file?

    Did the design change? (columns added or removed?)

    Are you running the package in 32-bit?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • March 19, 2012 at 8:23 am

    #1461148

    Yes it does have header excel sheet. Also i m running the package in a 32 bit machine but i did set the runtime to 64 bit

    Thanks

  • March 19, 2012 at 8:29 am

    #1461153

    PradeepVallabh (3/19/2012)

    Yes it does have header excel sheet. Also i m running the package in a 32 bit machine but i did set the runtime to 64 bit

    Thanks

    Do not do that. Leave it to 32-bit. The JET OLE DB provider used to read Excel files doesn't work in 64 bit.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 4 posts - 1 through 3 (of 3 total)

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