SSIS - Class not registered (0x80040154) Excel Source
Just a quick note that if you are developing SSIS
packages with Excel on a 64 bit machine you need to make sure the package is
configured to not use 64bit runtime. There are no 64bit Excel drivers (Jet) and
so whilst you code works in the desiger, i.e. getting fields and doing previews
etc it won't work at runtime. Thats because the designer is 32bit and the
runtime defaults to 64bit on a 64bit machine.
So how do you achieve this. You need to go into the Project Properties and
select the Debugging node on the left and then change the Run64bitRuntime to
false.
-