Forum Discussion

sivakumar44's avatar
sivakumar44
Copper Contributor
Mar 16, 2024

Unable to preview the file in Azure Data Factory - Failure

Hi,

I have created a pipeline in Azure Data Factory to migrate a table from MS SQL Server and loaded the table in Azure Data Factory. But unable to preview the table and getting the below error. Please look into this and help me to get this fixed.

 

'Type=Newtonsoft.Json.JsonSerializationException,Message=Error getting value from 'Value' on 'System.Data.SqlTypes.SqlDouble'.,Source=Newtonsoft.Json,'

'Type=System.Data.SqlTypes.SqlNullValueException,Message=Data is Null. This method or property cannot be called on Null values.,Source=System.Data,'

 

Thanks and Regards,

R. Sivakumar

  • JuriaanVanOosterom's avatar
    JuriaanVanOosterom
    Copper Contributor
    Mar 17, 2024

    sivakumar44 Hallo. There could be many things wrong here. Most likely the mapping of the source is not correct. Ensure that in adf all the columns of the source table are imported and all have a column type property set. But most easy way is to remove the currently imported columns from the mapping and 'Re import ' all. Often this resolves issues.

Resources