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

Question

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

Macrobond User 1

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?

ShaikMaheer-MSFT 38,551 Reputation points Microsoft Employee Moderator

2022-05-19T15:49:40.077+00:00

Hi @Macrobond User ,

Just checking in to see if the below answer helped. If this answers your query, do click and upvote for the same. And, if you have any further query do let us know.
Sreelakshmi N S 31 Reputation points

2022-11-13T08:20:46.98+00:00

Hi @ShaikMaheer-MSFT ,

I have tried setting up the SKIP incompatible rows. But it has failed again with the same kind of error while extracting the data.

Is it like an error from salesforce side or ADF?

1 answer

Your answer

ShaikMaheer-MSFT 38,551 Reputation points Microsoft Employee Moderator

2022-05-19T15:49:40.077+00:00

Hi @Macrobond User ,

Just checking in to see if the below answer helped. If this answers your query, do click and upvote for the same. And, if you have any further query do let us know.
Sreelakshmi N S 31 Reputation points

2022-11-13T08:20:46.98+00:00

Hi @ShaikMaheer-MSFT ,

I have tried setting up the SKIP incompatible rows. But it has failed again with the same kind of error while extracting the data.

Is it like an error from salesforce side or ADF?

Answer 1

ShaikMaheer-MSFT 38,551 Microsoft Employee Moderator

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.

Please let us know how it goes.

Share via

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

1 answer

Your answer