If your reading this error, your probably experiencing what I did today when trying to run an SSIS package on a 64 bit machine that has a connection manager to Excel. It seems that the Excel, and Access Jets have issues communicating with SQL Server 2008. There is a work around fortunately and it involves running the package using DTExecute via the X86 Program Files Directory. The way I handled it was to create a batch file to run the package similar to the below script and save it as a BAT file:
“D:Program Files (x86)Microsoft SQL Server100DTSBinndtexec.exe” /f “D:Test.dtsx” /X86
Another way to do it is schedule it to run as a job and then check the Use 32 bit Runtime checkbox in the execution options of the job like below:
Thanks for the tip. You made my day