Thanks for the reply. I resolved it by importing a schema before copy.
Facing below error while copying from azuredb to oracle
I am facing the below issue while copying azure db table to oracle. Can someone please help
Operation on target CopyWholetabledata failed: Failure happened on 'Sink' side. ErrorCode=UserErrorOdbcOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Failed to add value to the parameter array. ParameterName=ROWID, ValueType=WCHAR, ParameterType=VARCHAR, ColumnSize=-1, ElementBufferSize=-1, Precision=0, Scale=0, Length=0, Value=7be898e4-c152-4c84-9efc-2ec0b56b2231, ValueLogicalType=System.Guid,Source=Microsoft.DataTransfer.ClientLibrary.Odbc.OdbcConnector,''Type=Microsoft.DataTransfer.ClientLibrary.Odbc.Exceptions.OdbcBulkCopyException,Message=Failed to add value to the parameter array. ParameterName=ROWID, ValueType=WCHAR, ParameterType=VARCHAR, ColumnSize=-1, ElementBufferSize=-1, Precision=0, Scale=0, Length=0, Value=7be898e4-c152-4c84-9efc-2ec0b56b2231, ValueLogicalType=System.Guid,Source=Microsoft.DataTransfer.ClientLibrary.OdbcBulkCopy,''Type=System.InvalidCastException,Message=Object must implement IConvertible.,Source=mscorlib,'