Error 2200 Value was either too large or too small for a Decimal

Macrobond User 1 Reputation point
2022-05-04T11:53:06.44+00:00

Hi,

I've set up a linked service to Salesforce, created a dataset and now I'm trying to copy data from several objects (tables) in Salesforce.
All but one gets copied just fine....However, I get a error 2200 message when I try to import one of them, see below:

Failure happened on 'Source' side. ErrorCode=UserErrorUnclassifiedError,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Odbc Operation Failed.,Source=Microsoft.DataTransfer.ClientLibrary.Odbc.OdbcConnector,''Type=System.OverflowException,Message=Value was either too large or too small for a Decimal.,Source=System.Data,'

Any ideas?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,163 questions
{count} votes

1 answer

Sort by: Most helpful
  1. ShaikMaheer-MSFT 38,401 Reputation points Microsoft Employee
    2022-05-05T07:23:31.067+00:00

    Hi @Macrobond User ,

    Thank you for posting query in Microsoft Q&A Platform.

    I suspect it is due to bad data. Kindly consider enabling the "skip incompatible rows" and see if that helps.

    199142-image.png

    Please let us know how it goes.

    0 comments No comments