move file from source to sink

arkiboys 9,666 Reputation points

I am trying to move the processed .csv file from source to sink
I am using filesystem in Copy activity...
but the message I get is as follows:
Any suggestions?
Thank you

The file path provided is invalid. Host: '\\serverName\FolderName\subFolderName', Folder: 'Archive', File: 'FileName2021-11-22T16:32:16.4423375Z.csv'.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.NotSupportedException,Message=The given path's format is not supported.

The expression I use in the parameter of the sink dataset is: (

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,751 questions
0 comments No comments
{count} votes

Accepted answer
  1. HimanshuSinha-msft 19,381 Reputation points Microsoft Employee

    Hello @arkiboys ,
    Thanks for the ask and using Microsoft Q&A platform .
    In the file name you have character ":" which is making it fail . Use a replace function and it shoulld help .
    Something like (replace(

    Please do let me know how it goes .


    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators
    0 comments No comments

0 additional answers

Sort by: Most helpful