SSIS Supports only 32-bit runtime if dealing with EXCEL Files.

When SSIS package is dealing with EXCEL Files (Reading & writing Data from/into Excel Files) & if this package is set to run through SQL SERVER Job, the job fails with this error message. “Excel Connection Manager is not supported in the 64-bit version of SSIS.”

In this case, we need to run the job using 32-bit runtime. We can set 32-bit runtime in the Job execution option and once we do this job executes without any failure.

Leave a Reply