move file from source to sink

arkiboys 7,901 Reputation points
2021-11-22T16:38:06.663+00:00

Hello,
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:
@markus.bohland@hotmail.de (
split(item().EntityName,'.')[0],
utcnow(),
'.',
split(item().EntityName,'.')[1]
)

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

Accepted answer
  1. HimanshuSinha-msft 17,721 Reputation points Microsoft Employee
    2021-11-23T01:09:49.427+00:00

    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

    @markus.bohland@hotmail.de (replace(
    split(item().EntityName,'.')[0],
    utcnow(),
    '.',
    split(item().EntityName,'.')[1]
    )),':','_')

    Please do let me know how it goes .
    Thanks
    Himanshu

    -------------------------------------------------------------------------------------------------------------------------

    • 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
    No comments

0 additional answers

Sort by: Most helpful