Forum Discussion

rosscortb's avatar
rosscortb
Copper Contributor
Mar 20, 2024

Moving a xlsx file to a local network drive

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. 

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

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

No RepliesBe the first to reply

Resources