SSIS – how to find if Attunity 32 bit or 64 bits drivers are used

Category: SSISTags: , ,

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

Share

0 comments

Your email address will not be published. Required fields are marked *