0

I'm trying to fetch data (source) from SQL server to create a text file in ADLS (Sink), but I'm facing conversion overflow error. which I found out is with this value (999999999.00000000000000000000). can someone help me on this. I used Cast function in SQL server to make it an integer value & it did work, but I want to load the values as they are in the source without changing their type. Actually I want to load multiple tables at once. Screen shot is also attached with. Thanks

Daniel Mann
  • 57,011
  • 13
  • 100
  • 120
BM Baloch
  • 3
  • 2

1 Answers1

0

I tried to reproduce your scenario in my environment, and I got similar kind of conversion overflow error.

enter image description here

The cause of error may be ADF is unable to handle the decimal values where Precision > 28 to resolve this the work around is, if possible, make your Precision <=28

  • When I reduced the Precision value from 30 to 28 for my column with decimal datatype it worked. enter image description here
  • pipeline worked successfully. enter image description here

Output enter image description here

Pratik Lad
  • 4,343
  • 2
  • 3
  • 11