Reading data from multiple Excel files dynamically using SSIS: Part 1

if I have 50 k excel record then my ssis package working successfully but when I put more then 8lacs records in same excel and run same package then i have received an error message
Not enough storage is available to process this command (exception from hresult:0x80070008)

how to work with different formatted excel sheets.. what if excel 1 has 2 columns and if excel 2 has 3 columns? how to work in such scenario?

Thank you but you don't think how to generate a lot of file excel with the OLE DB :D

IS IT WORKING?

appreciate your effort ..but not clear about setting the excel file path settings!