Hi Guys,
Any one know if I will store xml in the azure blob storage, how to access the blob and get the xml in Sql server.
Regards
Rohit
Hi,
If you save the xml file in azure blob storage, we can get the file via code or Azure Storage Explorer. For more information about how to read the Azure blob content, please refer to https://azure.microsoft.com/en-us/documentation/articles/storage-dotnet-how-to-use-blobs/. If you want to use tool to download the file, please try use Azure Storage Explorer: https://azurestorageexplorer.codeplex.com/. If you set the Azure container as public, we can easily get the content via the blob URL: https://azure.microsoft.com/en-us/documentation/articles/storage-manage-access-to-resources/. We can use OPENXML to export data to Sql server table when get the xml content, refer to https://msdn.microsoft.com/en-us/library/ms186918.aspx for more details about OPENXML. Hope this helps, if I misunderstand, please feel free to let me know.
Best Regards,
Jambor