Moving a xlsx file to a local network drive

Copper Contributor

Hello,

I have a new xlsx file that goes into a container within a blob storage each day with the following file path -@concat('WGS_Extract_UK_', formatDateTime(utcNow(), 'yyyyMMdd'), '.xlsx')

 

I want to move the xlsx file to a local network drive.

I have created a dataset for the xlsx and preview the data and that's working

I have created a dataset for the file system linked service which allows me use excel as my output. 

rosscortb_0-1710937015790.png

In the next screen I've selected the folder I want the file to go to (UK)

rosscortb_1-1710937203610.png

I then created my pipeline copy activity, the source I select, the xlsx data set but for the sink, it doesn't give me the option to select the dataset I created for the local drive.

 

Any ideas please?

Thanks

Ross

0 Replies