Search code examples
azure-data-lakeazure-synapseazure-data-factory

Azure Synapse Copy Data Tool conversion overflow error while creating text files in ADLS gen2

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

Solution

  • 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