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

By | February 15, 2018

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

 

Vishal Monpara is a full stack Solution Developer/Architect with 13 years of experience primarily using Microsoft stack. He is currently working in Retail industry and moving 1’s and 0’s from geographically dispersed hard disks to geographically dispersed user leveraging geographically dispersed team members.

Leave a Reply

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