How to copy files from FTP and put them in a folder with current datetime

Copper Contributor

I am use Azure Synapse's Copy Data in pipeline.

I configured the SFTP. I can copy files from the FTP server to synapse filesystem.

 

Now how configure sink to everytime it grabs the files it puts it in a folder with datetime name?

 

Is this the right approach?

 

How to do it?

0 Replies