Copy data(.csv) from Sql server to Azure Blob Storage(ADLS2) using Azure Data Factory

Question

I am trying to copy data from Sql to Blob storage using Azure data factory. Although I was able to load the data and creating a trigger for a specific time frame, but not sure how to provide a filename with a timestamp in data factory for every load that occurs weekly. Basically adding a dynamic content where I can mention my file name with date stamped

Can anyone suggest on how to achieve this on data factory?

sample output : filename1_29042022.csv

Moulitharan M · Accepted Answer · 2022-04-29 01:09:16Z

2

use the below code as dynamic content in file name [art of the sink dataset. this returns filename_20220428.csv

@concat('filename', '_', replace(formatDateTime(convertTimeZone(utcnow(),'UTC','Eastern Standard Time'),'yyyy-MM-dd'),'-',''), '.csv')

answered Apr 29, 2022 at 1:09

Moulitharan M

7494 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Copy data(.csv) from Sql server to Azure Blob Storage(ADLS2) using Azure Data Factory

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related