none
Need to import a file as it is from azure blob to azure sql

    Question

  • Hi Team, 

    I need to insert records from a CSV which is hosted in azure blob to a azure sql. I need to achieve this through a SP using a bulk insert. 

    Please help me if you have any code/ implementation steps. 

    Thanks,

    Vikram 

    Friday, September 21, 2018 5:56 AM

All replies

  • hi Vikram,

    ADF Copy Activity can support copy from Azure Blob Csv to Azure Sql (which will use bulk insert), which just need to create a Copy Activity from UI and doesn't need to implement any code. (please see https://docs.microsoft.com/en-us/azure/data-factory/supported-file-formats-and-compression-codecs#text-format )

    Please let me know if it can't satisfy your requirement.

    Regards,

    Gary

    Friday, September 21, 2018 6:28 AM
  • Hi Gary,

    Yes. whatever it is true and possible. But according to my requirement it should be through SQL code (stored procedure). 

    Thanks,

    Vikram 


    Friday, September 21, 2018 8:37 AM