This is a design time setting only and doesn't affect the execution of a package on the server.

However, you might be on the right track: it's possible the server is 64-bit and hasn't the 64-bit providers installed, something Alvin was also guessing at.