question

ks567 avatar image
0 Votes"
ks567 asked HimanshuSinha-MSFT commented

Azure Data Factory, Validate Specficic file in SFTP

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
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello anonymous user ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .
Thanks
Himanshu

0 Votes 0 ·

1 Answer

NandanHegde-7720 avatar image
0 Votes"
NandanHegde-7720 answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.