Fast Load Mode not working in SSIS Dataflow Task's OLEDB Destination (Oracle)

Question

I am mirroring the tables from Sql server to Oracle. So its working absolutely find when I choose sql command as Data access mode. But I have millions of records in my table so wanted to switch Table or view -fast load access mode. As soon as I select fast load as data access mode it is showing me this error. Not able to click on mapping option and is throwing below error

Below is the error details TITLE: Microsoft Visual Studio Exception from HRESULT: 0xC0202040 Error at TABLE_NAME [OLE DB Destination [266]]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21. An OLE DB record is available. Source: "OraOLEDB" Hresult: 0x80040E21 Description: "The system cannot find message text for message number 0x80040e21 in the message file for OraOLEDB.". Error at TABLE_NAME [OLE DB Destination [266]]: Failed to open a fastload rowset for ""USERSCHEMA"."TABLE_NAME"". Check that the object exists in the database.

Can somebody please advise here what needs to be done ??

Answer 1

Disable 64bit runtime in properties of project. It will work.