Microsoft connector helps to attain better performance than any built-in connectors of SSIS during loading or unloading of the data from Oracle DB. It has similar configuration and UI as SSIS built-in OLEDB connector. It uses Oracle’s OCI client with its Array Binding and Direct Path APIs to deliver high speed data transfer: It is available to download from Microsoft or Attunity web site for SQL Server Enterprise user at no cost. Attunity has three main components Oracle source, Oracle destination and Oracle connection manager.
Please use below link top download 3.0 version for SSIS 2014
https://www.microsoft.com/en-us/download/confirmation.aspx?id=44582
Please use below link top download 2.0 version for SSIS 2012
https://www.microsoft.com/en-us/download/details.aspx?id=29283
Error Message :
The connection type “MSORA” specified for connection manager
is not recognized as a valid connection manager type.
The solution for above message is to download the connector and install.
