@Abhijith Yamsani 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. 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.

I'm attempting to use Data Factory to transfer a CSV file from my computer to Azure Data Lake. I'm unable to select the path to the file I want to migrate from my local computer when I try to link the file system in the data factory's source tab.

Abhijith Yamsani 0

User's image

PRADEEPCHEEKATLA 90,226 Reputation points

2023-03-13T05:36:36.22+00:00

@Abhijith Yamsani Just checking in to see if the below answer helped. 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.
PRADEEPCHEEKATLA 90,226 Reputation points

2023-03-15T05:02:06.25+00:00

@Abhijith Yamsani We received your feedback that the answer provided on the thread was not helpful.

Kindly let us know what we could have done better to improve the answer and make your engagement experience good. We are here to help you and strive to make your experience better and greatly value your feedback.

I had provided a detailed answer with an official documentation which has clear steps for which you are looking for.

If you wish, you may re-surveying/rating for the engagement you received on the thread. Your feedback is very important to us.

Looking forward to you reply. Much appreciate your feedback!

Regards,

PRADEEPCHEEKATLA-MSFT
Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Gustavo Henrique Bavia 0 Reputation points

2023-05-15T11:39:13.18+00:00

.....
Gustavo Henrique Bavia 0 Reputation points

2023-05-15T11:40:41.2933333+00:00

.....

1 answer

PRADEEPCHEEKATLA 90,226 Reputation points

2023-03-10T08:07:03.0566667+00:00

@Abhijith Yamsani 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.

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.
Please sign in to rate this answer.
Abhijith Yamsani 0 Reputation points

2023-03-15T03:01:47.66+00:00

Hello, Pradeep. I followed the steps for the answer, however the problem is "Access to 'C:forazure' is not permitted. b67875f5-85b5-492c-8b65-96ed9166d04b Activity ID "I have added all of the folder's appropriate permissions; is there a problem with the username and password?

What should the user name be?

PRADEEPCHEEKATLA 90,226 Reputation points

2023-03-15T04:56:46.2366667+00:00

@Abhijith Yamsani As I mentioned above the hostname should be:

Host: DriveLetter:\FolderName\

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

What should the user name be?

Specify the ID of the user who has access to the server.

To find the currently logged-in user name in the Windows operating system, use the %username% environment variable.

Note: If you are on domain you should use username as user@organization.com and password should works.

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

Abhijith Yamsani 0 Reputation points

2023-03-15T17:49:19.7+00:00

yes i followed all the instructions but still im not able to establish a connection

Abhijith Yamsani 0 Reputation points

2023-03-15T22:43:50.0533333+00:00

D:\Azure\ **

PRADEEPCHEEKATLA 90,226 Reputation points

2023-03-20T05:25:31.36+00:00

@Abhijith Yamsani Can you please confirm if the D:\Azure\ exists - share the screenshot as shown above?

Abhijith Yamsani 0 Reputation points

2023-03-21T01:03:59.4733333+00:00

Yes

PRADEEPCHEEKATLA 90,226 Reputation points

2023-03-21T06:00:43.1466667+00:00

@Abhijith Yamsani Can you please confirm if you have proper permission on the D:\Azure\?
To resolve this issue, you will need to grant the appropriate permissions to the user or service account that the Azure Data Factory is running under. Here are the steps you can follow:

Open File Explorer and navigate to the "D:\Azure" directory.

Right-click on the directory and select "Properties".

In the Properties window, select the "Security" tab.

Click the "Edit" button to change permissions.

Click "Add" to add the user or service account that the Azure Data Factory is running under.

Enter the appropriate user or service account name and click "Check Names" to verify.

Click "OK" to close the Select Users or Groups dialog box.

In the Permissions window, select the user or service account you just added and grant it the necessary permissions (e.g., "Full Control").

Click "OK" to save the changes.

Hope this helps.

PRADEEPCHEEKATLA 90,226 Reputation points

2023-03-23T07:23:25.59+00:00

@Abhijith Yamsani - Following up to see if the above suggestion was helpful. And, if you have any further query do let us know.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.