In your first post, you said that you were reading from an Excel file from a SSIS package. How did you achieve this?

I have attached a screenshot of a simple package that has an Excel source. I have indicated the connection manager and the property that you should modify. Hope this helps...

EDIT: another hint: you should create the Excel connection manager yourself. Either in the Excel Source component by selecting New, or by right-clicking in the connection managers window, choosing New Connection and then picking Excel from the list.