We are creating an SSIS 2012 package to take data from Oracle in to SQL server using Oracle Attunity driver.
We used intermediate table approach.
We created an intermediate table on SQL server side and brought all the data from Oracle to SQL server and then moved the data into final SQL server.
The timestamp field on Oracle was mapped to varchar (75) on SQL server intermediate table side.
The date field on Oracle was mapped to datetime and not datatime2 on SQL server intermediate table side. By default the software tries to use datetime2, which we were unable to make it working.