I accidentally posted this in the wrong area.

I've setup a CDC connection between SQL Server and Oracle databases to track changes in Oracle. The status according to the CDC Manager switchs to Logger and can never recover so I turned on Trace so that I can get a better picture of what is happening. Below is the error I'm getting. So, I need to know the recommended way to get date fields from Oracle into SQL Server using Attunity CDC Manager. In doing straight SSIS I can use Data Conversion to accomplish the same task.


ORACDC423E:ODBC error: RetCode: SQL_ERROR SqlStat: 22008 NativeError: 0 Message: [Microsoft][SQL Server Native Client 11.0]Datetime field overflow. Fractional second precision exceeds the scale specified in the parameter binding.","infrastructure"