Forum Discussion
rosscortb
Mar 20, 2024Copper Contributor
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