Either convert to 2003 Excel, .xls, or use the following method:
Using Excel 2007 files as a Source in SSIS 2005[/url]
Or upgrade to a recent version of SSIS, that's also an option.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP