I've written several SSIS packages in SSIS 2012. The development environment is Windows 7 (32-bit).
I'll be installing the SSIS packages on a Windows 8 machine (64-bit).
I'm running Microsoft Access Database Engine 2010 Redistributable (32-bit) on my development environment as the SSIS packages do quite a bit of manipulation with Excel files.
My question is, when I install the SSIS packages on the Windows 8 (64-bit) machine (machine will *NOT* have Microsoft Office installed), which version of Microsoft Access Database Engine 2010 Redistributable will I need to install there?
What little I've found online on this seems to lead me to believe that since I'm developing in a 32-bit environment and have my coding in SSIS geared towards the 32-bit Microsoft Access Database Engine 2010 Redistributable, I need to stick with installing the 32-bit Microsoft Access Database Engine 2010 Redistributable on the production machine even though the production machine is 64-bit.
Any suggestions here are greatly appreciated.