I am trying to read tables from SAP using ABAP data flow, in SAP data store settings we used data transfer method as RFC and job failing with below error
"ODBC data source <QADB> error message for operation <SQLExecute><[Microsoft][SQL Server Native Client 10.0]Invalid character value for cast specification>"
when i change Data transfer method from RFC to shared directory , its working fine. I just didn't get it.
can you please help me if you have faced this issue before or any idea about this issue.
Thanks a lot