I had this error way back in the day. If you are using a new version of Excel - 2010 and you SQL Server Version is 2008 the Jet engine in Excel 2010 is incompatible with SSIS 2008. You will not encounter this Jet Engine error if you use Excel 2007 and earlier. Hope this helps.