Irrespective of whether your Microsoft SQL Server instance or Windows environment are 64-bit, SSIS applications are developed with the Visual Studio IDE.
The Visual Studio IDE, up to and including VS2017, is a 32-bit application and as a result, for such development all OLE DB and .NET Providers must be 32-bit, as must any subsequently interfaced components such as ODBC drivers.
When you deploy your final SSIS package --
Thus, if developing and deploying on the same 64-bit Windows host, you may need to install both 32-bit and 64-bit versions of all data access components.
| 32-bit SQL Server on 32-bit Windows (Development or Deployment) | 32-bit SQL Server on 64-bit Windows (Development or Deployment) | 64-bit SQL Server on 64-bit Windows (Development and Deployment) | 64-bit SQL Server on 64-bit Windows (Development & Debugging only) | 64-bit SQL Server on 64-bit Windows (Deployment only) | |
| 32-bit Visual Studio IDE | Y | Y | Y (development & debugging) | Y | N |
| 32-bit .Net Provider | Y | Y | Y (development & debugging) | Y | N |
| 32-bit ODBC Driver | Y | Y | Y (development & debugging) | Y | N |
| 64-bit .Net Provider | N | N | Y (final deployment) | N | Y |
| 64-bit ODBC Driver | N | N | Y (final deployment) | N | Y |