0

I've been trying to import data from a file into a table in SQL Managed Instance. I was able to successfully import data from a text file and an Excel file that I uploaded in a Blob container in Azure Storage to my desired tables in SQL Managed Instance. While that is all good, I already have a structure set up in a shared location and I was wondering whether it is possible to be able to import data from files in that location in my network to SQL Managed Instance or not?

Kate Orlova
  • 3,225
  • 5
  • 11
  • 35
Abdinassir
  • 11
  • 3
  • For Azure SQL database/managed instance, it only support load files from Azure storage. – Leon Yue Sep 11 '20 at 01:38
  • Hi @Abdinassir, If my answer is helpful for you, you can accept it as answer( click on the check mark beside the answer to toggle it from greyed out to filled in.). This can be beneficial to other community members. Thank you. – Leon Yue Sep 15 '20 at 00:46
  • Hello @Abdinassir, haven't heard you for a long time, do you have any other concerns? – Leon Yue Sep 16 '20 at 00:50

1 Answers1

0

For Azure SQL database/managed instance, it only support load files from Azure storage.

It doesn't support access file from the network or file shares. Ref this feedback: enter image description here

Leon Yue
  • 15,693
  • 1
  • 11
  • 23