This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 67%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECW%3C/text%3E%3C/svg%3E)
I'm writing data from Azure SQL Database to an SFTP folder using Azure Data Factory V2 copy activity.
The data is written successfully, however, the filename uses a default file structure. I need to adjust this filename to a new naming convention - however, there doesn't seem to be any way to do so with the copy data activity options:
Hi @Cameron Warren ,
Just following up to see if the above answer helped. Please do consider clicking Accept Answer and Up-Vote for the same as accepted answers help community as well. If you have any further query do let us know.
Hi @Cameron Warren ,
Just following up to see if the below answer helped. Please do consider clicking Accept Answer and Up-Vote for the same as accepted answers help community as well. If you have any further query do let us know.
Hey,
WIthin the dataset you can Parameterize the file name
Reference :
https://gbamezai.medium.com/azure-data-factory-capture-dynamic-filenames-in-mapping-data-flow-6b58cd6654f8
Hi @Cameron Warren ,
Just checking in to see if the above answer helped. Please do consider clicking Accept Answer and Up-Vote for the same as accepted answers help community as well. If you have any further query do let us know.