Loading Json Data(ADLS ) To Azure SQL Database RRS feed

  • Question

  • Hi All,

    I am not able to load Json data which is in ADLS Gen2 to Azure SQL Database  through Azure Data Factory (Copy Data) Activity.

    sample Json Data:


    { "1": { "_id": "1", "id": "1", "Name": "Paragraph", "canBeRetrieved": false },

       "2": { "_id": "2", "id": "2", "Name": "Paragraph", "canBeRetrieved": true }



    If any aone already worked on this kind of requirement , please help me.


    Vijayakumar P

    Friday, July 24, 2020 10:29 AM

All replies

  • Hi Vijayakumar Panabaka,
    I viewed your description, it is mainly related to Azure. So it is recommended to go to Azure forum and you can get more professional answer. 
    Thank you for your understanding.
    Best Regards,
    Daniel Zhang

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Monday, July 27, 2020 6:27 AM