Hello,
We are trying to migrate from Informatica to Data Factory. I'm attempting to do a simple pipeline copy activity to replace a process that works fine in Informatica and am getting the following error message. Any help would be greatly appreciated. This copy activity is from a SQL database to an Oracle table.
Error code: 2200
Failure type: User configuration issue
Details: Failure happened on 'Sink' side. ErrorCode=UserErrorOdbcOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ERROR [HY000] [Microsoft][ODBC Oracle Wire Protocol driver]Error tolerance exceeded. Bulk load operation terminated. Error in parameter 7. ERROR [22001] [Microsoft][ODBC Oracle Wire Protocol driver]String data, right truncated. Error in row 1. Error in parameter 7.,Source=Microsoft.DataTransfer.ClientLibrary.Odbc.OdbcConnector,''Type=Microsoft.DataTransfer.ClientLibrary.Odbc.Exceptions.OdbcException,Message=ERROR [HY000] [Microsoft][ODBC Oracle Wire Protocol driver]Error tolerance exceeded. Bulk load operation terminated. Error in parameter 7. ERROR [22001] [Microsoft][ODBC Oracle Wire Protocol driver]String data, right truncated. Error in row 1. Error in parameter 7.,Source=msora28.dll,'

