SSIS - Connection manager working on preview but no working when running package

If you are trying to pull data and the connection manager is working fine and you are able to preview the tables from the database, but when you run the package it fails, the problem is the driver used to connect, it doesn't support 64 bit or you don't have a 64 bit installed.

You probably get errors like:

• Error: SSIS Error Code DTS_E_OLEDB_NOPROVIDER_64BIT_ERROR.  The requested OLE DB provider OraOLEDB.Oracle.1 is not registered -- perhaps no 64-bit provider is available.
• [Execute SQL Task] Error: Failed to acquire connection "NADCWDDBS01A_INS01A.LegalReview". Connection may not be configured correctly or you may not have the right permissions on this connection.
• Etc.

To solve the problem:

1. Go to your SSIS project properties
2. From Configuration properties select Debugging
3. On the Data Flow Optimizations change the option Run64BitRuntime to false