Great article - I'm looking for clues to solve the following problem.

Right now, my scheduled SSIS package (SQL08) to import Excel spreadheet data into SQL 08 works when the Excel spreadsheet is closed. It also works when the spreadsheet is open if I run the job manually from the Import Data wizard.

However, the scheduled SSIS package fails with the 'Jet engine cannot open file' error when the spreadsheet is open.

Is it possible to schedule an SSIS package to import data from an open Excel file to SQL Server?

Many thanks for any tips.