Revision history [back]

The process of dynamically naming files in ADF when transferring BLOB data through Data Flow and copying it into SQL Database using Copy Activity involves the following steps:

1. Create a parameter in ADF to store the file name.

2. In the Data Flow source transformation, use the "Derived Column" transformation to set the value of the parameter to the desired file name.

3. Use the "Sink" transformation to write the output of the Data Flow to Blob Storage, using the parameter as part of the file name.

4. In the Copy Activity, use the "Blob Source" to specify the Blob Storage location and the file name using the same parameter.

5. Use the "SQL Server Sink" to write the data to the SQL Database.