This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I am trying to read SAP Table into a data set in ADF but getting below error :
This is the only table out of 88 causing problem and this table is working and being used perfectly in SAP.
Failed when parsing data, parsing value: '1 PANDEY202', expected data type 'Microsoft.DataTransfer.Common.Shared.ClrTypeCode'.Please check your origin data in SAP side
Input string was not in a correct format.
Activity ID: 9e85d0e9-0762-4bef-ae1f-e5a3de8f0b0c
Hi @Anonymous ,
Welcome to Microsoft Q&A platform and thanks for posting your question here.
From the error message, it can be derived that the target dataset is expecting datatype other than what is there in the Source.
Could you please share more details like what is the target datastore in your case? In case if the sink is SQL DB, kindly share the create table script if possible.
It would be helpful if you could share the screenshot of the ADF pipeline as well. Looking forward to your response. Thankyou
Hi
for your info :
Sink - JSON
Source - SAP Table
All other setting are default default.
There is nothing much in Pipeline to show but still you wanna see i can send a screenshot.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 97%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZY%3C/text%3E%3C/svg%3E)
Hi, @Hi @Anonymous ,
Thank you raise issue and ask help from Microsoft product team, could you do as following steps to provide related SHIR logs to us for trouble shooting?
Activity ID: 9e85d0e9-0762-4bef-ae1f-e5a3de8f0b0c
Operation: preview data
Region: East US
Share SHIR Logs:
Thanks!
Hi @Anonymous ,
Just checking if you got a chance to visit the previous response. Kindly share the required information to proceed further. Looking forward to your response . Thanks