Problem with establisng Linked Service for File system

Question

Hello,

I am trying to migrate an Excel file from the separate computer to a container in Azure Storage Account using Azure Data Factory.

I have already downloaded the self-hosted IR and installed it on the separate computer. It works properly in ADF.

Moreover, I have shared a folder on the separate computer.

I have a problem with establishing Linked Service. I really don't know what I should enter as USER NAME and PASSWORD. I assume that the field HOST is filled in correctly.

Could you help me with this, please? Thank you in advance.

Konrad

Answer 1

Hello @Konrad Majcherczyk !

You are on the right track. A self-hosted integration runtime (IR) is required for copying files from your local file system to Azure Storage.

The Linked Service configuration for a File System requires three pieces of information:

Host: This is the name of the machine where the file resides. If the file is on the same machine as the Self-Hosted IR, you can use 'localhost'. If it's on a different machine, use the machine's network name or IP address.

User name: This is the username of a user account on the host machine that has permissions to access the file you want to copy. The username should be entered in the format Domain\Username or MachineName\Username if you don't have a domain. If you are on a Windows machine, you can find out your machine name by opening a command prompt and typing hostname.

1. Password: This is the password for the user account you specified in the User Name field.

Also the resources should be able to communicate with each other on the network level !

I hope this helps!

Kindly mark the answer as Accepted and Upvote in case it helped!

The answer or portions of it may have been assisted by AI Source: ChatGPT Subscription

Regards

Answer 2

@Konrad Majcherczyk - Thanks for the question and using MS Q&A platform.

You may follow the following steps to select the csv or any file file while creating File system as source:

First create a linked service as follows:

Host: DriveLetter:\FolderName\

Example: I'm using C Drive which has a folder named AzureLearn

Create a copy activity and select Source as follows:

Click on Source => New

Select New DataSet => Select File => File System and continue

Select Format= > Choose DelimitedText and continue

Select previously created File system linked service and click on browse.

Choose a file or folder.

Here you can find the file located under the previously selected folder while creating File System.

As per the repro, I'm able to find the path which I want to migrate to ADLS gen2.

In case, if you are experiencing error code: 22853 Access to path on vm is not allowed.

Check out the solution provided here: https://learn.microsoft.com/en-us/answers/questions/1286363/cant-connect-to-integration-service-file-system-ac

Hope this helps. Do let us know if you any further queries.

---

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.