SSIS – How to Find If Attunity 32 Bits or 64 Bits Drivers Are Used

Here is a simple flowchart to find out if the Attunity 32-bit or 64-bit drivers are going to be used when executing SSIS package. Please note that the answer does not depend on the if the database engine is 32-bit or 64-bit.

• Are you running SSIS from Visual Studio?
  • If yes, then check if SSIS Project property > Configuration Properties > Debugging > Run64BitRunTime = true
    • If yes, then check if SSIS 64 bit runtime is installed on the machine?
      • If yes, then Attunity 64 bit drivers will be used
      • If not, then Attunity 32 bit drivers will be used
    • If not, then Attunity 32 bit drivers will be used
• Are you running SSIS from SQL Agent or from command line using dtexec.exe?
  • If yes, then check if SSIS 64-bit version is installed on the machine.
    • If yes, then Attunity 64-bit drivers will be used
    • if not, then Attunity 32-bit drivers will be used