I have found the solution. I used excel 97-2003 format i.e., .xls it is working fine.
as mentioned in the above mail.. check the properties make Run64bitRuntime(right click on project,select properties and debugging) to false and delayvalidation to true
I think the problem SSIS is not considering excel 2007 i.e., .xlsx format. Rest it is fine.
If any comments or doubts please post your reply.
Thank you and Best Regards,