I have a SSIS package that contains a Data Flow, within that Data Flow is an Excel Source. I Visual Studio/BIDS I configure the Excel Source and point it at the file in question. I know it can read it because the preview returns the data.
However when I run the package from top to bottom it picks up the file but says "Error: opening a rowset for "mike$" failed". How it can it find the sheet in the designer but when you run it, it doesn't?
Any help greatly appreciated.