How to switch SSIS to 32-bit mode:

 




In Visual Studio (SSDT)

  1. Open your SSIS project.
  2. Go to Solution Explorer → Right-click the Project → Properties.
  3. In the Configuration Properties → Debugging section:
    • Set Run64BitRuntime = False.
  4. Save and re-run the package.
    This forces the package to use the 32-bit runtime during development/debugging.

Comments