= Special Considerations when using Visual Studio and/or Microsoft SQL Server as the Data Consumer, on 64-bit Windows = 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 [[http://www.quora.com/Why-is-Visual-Studio-2015-still-a-32-bit-application| 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 -- * A 64-bit Microsoft SQL Server instance (or non-SSIS VS project compiled as 64-bit) will require a 64-bit OLE DB or .NET Provider and (if applicable) a 64-bit ODBC driver. * A 32-bit Microsoft SQL Server instance (or non-SSIS VS project compiled as 32-bit) will require a 32-bit OLE DB or .NET Provider and (if applicable) a 32-bit ODBC driver, regardless of the Windows environment in which it runs. 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 %BR% on 32-bit Windows** %BR% (Development //or// Deployment) | **32-bit SQL Server %BR% on 64-bit Windows** %BR% (Development //or// Deployment) | **64-bit SQL Server %BR% on 64-bit Windows** %BR% (Development //and// Deployment) | **64-bit SQL Server %BR% on 64-bit Windows** %BR% (Development & Debugging //only//) | **64-bit SQL Server %BR% on 64-bit Windows** %BR% (Deployment //only//) | | **32-bit Visual Studio IDE** | **Y** | **Y** | **Y** %BR% (development & debugging) | **Y** | **N** | | **32-bit .Net Provider** | **Y** | **Y** | **Y** %BR% (development & debugging) | **Y** | **N** | | **32-bit ODBC Driver** | **Y** | **Y** | **Y** %BR% (development & debugging) | **Y** | **N** | | **64-bit .Net Provider** | **N** | **N** | **Y** %BR% (final deployment) | **N** | **Y** | | **64-bit ODBC Driver** | **N** | **N** | **Y** %BR% (final deployment) | **N** | **Y** | * **Y** indicates the component on the left must be installed. * **N** indicates it is not required, but it *may* also be installed. == Related == * [[Win32vs64OdbcAdmin|Using ODBC (32-bit and 64-bit) on 64-bit Windows]]