question

MacrobondUser-5634 avatar image
0 Votes"
MacrobondUser-5634 asked ShaikMaheer-MSFT commented

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

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
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @MacrobondUser-5634 ,

Just checking in to see if the below answer helped. If this answers your query, do click 130616-image.png and upvote 130671-image.png for the same. And, if you have any further query do let us know.

0 Votes 0 ·

1 Answer

ShaikMaheer-MSFT avatar image
0 Votes"
ShaikMaheer-MSFT answered

Hi @MacrobondUser-5634 ,

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.


image.png (99.3 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.