Azure Data Factory, Validate Specficic file in SFTP

Karthikeyan Shivasankaran 21 Reputation points
2021-03-22T08:02:03.39+00:00

In Azure Data factory, Expecting a file in SFTP everyday with file naming MS_yyyyMMdd.txt. how do I validate there should be always only one file and it is in correct naming format so that it can be copied from SFTP to ADLS. Appreciate you help.

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

1 answer

Sort by: Most helpful
  1. Nandan Hegde 29,896 Reputation points MVP
    2021-03-22T08:06:06.09+00:00

    Hey anonymous user
    You can use get meta data activity with SFTP as the source to validate whether there is any file with the required naming convention.
    And through copy activity, copy from SFTP into ADLS

    0 comments No comments