[TIPS] SSIS: Export data from SQL Server to Excel Fail

 Error Message: 

[Execute SQL Task] Error: Failed to acquire connection "DestinationConnectionExcel". Connection may not be configured correctly or you may not have the right permissions on this connection.

[Connection manager "DestinationConnectionExcel"] Error: The requested OLE DB provider Microsoft.Jet.OLEDB.4.0 is not registered. If the 64-bit driver is not installed, run the package in 32-bit mode. Error code: 0x00000000.

An OLE DB record is available.  Source: "Microsoft OLE DB Service Components"  Hresult: 0x80040154  Description: "Class not registered".

Solution:

Open the project property page, change Run64BitRuntime  from True to False.