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

Moore, Payton E 101 Reputation points
2021-03-29T12:47:53.44+00:00

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 Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,417 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,640 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Kiran-MSFT 691 Reputation points Microsoft Employee
    2021-03-29T16:12:37.813+00:00

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