How to load Azure VM local files to azure sql database using self-hosted IR?

70 Views Asked by At

I have an azure VM having csv files, i don't have storage account, so how to load VM local files into azure sql database using file system and self-hosted IR

1

There are 1 best solutions below

0
Bhavani On

You can get your username of VM as follows:

Open command prompt and execute whoami command, you will get username as mentioned below:

enter image description here

Create a file system linked service using SHIR with username and VM password and path is in \users\<filepath>\<filename> as mentioned below:

enter image description here

For more information you can refer this.