i try to move data from xlsx to csv folder in adls gen2 but in mapping data flow i used inside for each folder level i clean all files and remove special charcter in column name and move towords the sink but its showing an sink file like paer_123 but i wa

Question

i try to move data from xlsx to csv folder in adls gen2 but in mapping data flow i used inside for each folder level i clean all files and remove special charcter in column name and move towords the sink but its showing an sink file like paer_123 but i wa

Adarsh M 0

i try to move data from xlsx to csv folder in adls gen2 but in mapping data flow i used inside for each folder level i clean all files and remove special charcter in column name and move towords the sink but its showing an sink file like paer_123 but i want file name in csv i want file name so can anybody give me step by step solution

akrit pandey 0 Reputation points

2026-01-04T07:27:05.4233333+00:00
Sink File Name Option: Verify the "File name option" in the sink settings. If "Default" is selected, the system generates unique names like part-00000-....csv. If a specific name or expression is used, that expression needs review.

Dynamic Content: If using dynamic content for the filename, ensure the expression correctly references the current item in the "For Each" loop and extracts the desired name without errors or unintended characters.

Dataset Parameters: Check if the dataset used in the sink has parameters for the filename and if these parameters are correctly mapped in the data flow activity.

A definitive answer cannot be provided without further details about the configuration.

Disclaimer: This information is for general guidance on software configuration and does not constitute professional IT advice.

1 answer

Your answer

akrit pandey 0 Reputation points

2026-01-04T07:27:05.4233333+00:00

Sink File Name Option: Verify the "File name option" in the sink settings. If "Default" is selected, the system generates unique names like part-00000-....csv. If a specific name or expression is used, that expression needs review.

Dynamic Content: If using dynamic content for the filename, ensure the expression correctly references the current item in the "For Each" loop and extracts the desired name without errors or unintended characters.

Dataset Parameters: Check if the dataset used in the sink has parameters for the filename and if these parameters are correctly mapped in the data flow activity.

A definitive answer cannot be provided without further details about the configuration.

Disclaimer: This information is for general guidance on software configuration and does not constitute professional IT advice.

Answer 1

Hi ,

Thanks for reaching out to Microsoft Q&A.

This is a common Mapping Data Flow mistake. The reason Mapping Data Flow is writing the sink using file pattern/partitioned output, so it auto generates names like part-0000… or paer_123. It will never preserve the source file name by default.

You must explicitly pass and set the file name.

Capture source file name

In Source settings, enable Column -> Add new column

Add:

Column name: SourceFileName

  Value: `$$FileName`

This gives you the original xlsx name.

Clean column names

Do your existing logic (Derived column or Select) to remove special characters.

Do not touch SourceFileName.

Convert xlsx to csv

Keep transformations as-is.

Ensure sink format = DelimitedText (CSV).

Control sink file name

Go to Sink -> Settings
Enable File name option
Choose Output to single file (important)
Set File name expression: concat(replace(SourceFileName, ``'.xlsx'``, ``''``), ``'.csv'``) This forces the CSV to keep the original name.

Folder handling

Keep your ForEach at folder level.

Sink dataset path should point to the target folder only, not file.

Important truths (dont ignore)

Mapping Data Flow always generates part files unless you force single file.
You cannot rename files after sink inside Data Flow.
If performance matters and files are large, do ADF Copy Activity instead of Data Flow.

Recommended alternative (simpler & faster)

If you are only converting xlsx -> csv and renaming:

Use Copy Activity

Enable Preserve hierarchy

Use Dynamic file name in sink

afaik data flow is overkill for this scenario.

Please 'Upvote'(Thumbs-up) and 'Accept' as answer if the reply was helpful. This will be benefitting other community members who face the same issue.

Anonymous

2026-01-06T18:12:41.5966667+00:00

Hi @Adarsh M**
**
I hope you had a chance to review the information shared earlier, and I hope this information has been helpful! If you still have questions, please let us know what is needed in the comments so the question can be answered.

Share via

i try to move data from xlsx to csv folder in adls gen2 but in mapping data flow i used inside for each folder level i clean all files and remove special charcter in column name and move towords the sink but its showing an sink file like paer_123 but i wa

1 answer

Important truths (dont ignore)

Recommended alternative (simpler & faster)

Your answer