question

msftsyn7270 avatar image
0 Votes"
msftsyn7270 asked msftsyn7270 answered

Keeping File Name in Sink through a Data Flow (Azure Synapse)

I would like to keep the file name from my source file in my sink file. I have attempted to use parameters to get there, but am not finding a solution. I've created a parameter in my data flow called $filename, which I have placed in my wildcard path: /Incoming/$filename. I have added this parameter to my sink file name as well. No luck. What am I missing? Thanks for the help.

azure-data-factoryazure-synapse-analytics
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@msftsyn7270 Thanks for using Microsoft Q&A !!
What's your source and sink in your case, is it a blob storage ?

0 Votes 0 ·

Source and Sink are both in Azure Data Lake Storage Gen 2. Please let me know if I can provide any other helpful information. Thanks. @SaurabhSharma-msft

1 Vote 1 ·

1 Answer

Kiran-MSFT avatar image
0 Votes"
Kiran-MSFT answered SaurabhSharma-msft converted comment to answer

Add dynamic expression for the path. Type "/Incoming/{$fileName}" with the quotes

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@msftsyn7270 If Kiran's suggestion above doesn't work for you, then can you reply back here with the code snippet from the script behind your data flow graph? Click the Script button (not the code button) and then paste the source & sink definition here for us to review.

0 Votes 0 ·

@msftsyn7270 Did @Kiran-MSFT and @MarkKromer-8019 suggestions work for you ? If so, please mark as accepted answer. If not, please share the source and sink definitions here for further review.

0 Votes 0 ·