Can't find SFTP path XXX*.csv

Lilly W 130 Reputation points
2023-02-16T23:00:36.8+00:00

I have an ADF pipeline with a copy task. The source is a folder of files that need to be imported. Can you set the file path to something like this?
DailyImport*.csv

The error is:

Can't find SFTP path DailyImport*.csv

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

Accepted answer
  1. Subashri Vasudevan 11,231 Reputation points
    2023-02-17T03:34:41.86+00:00

    Hello @Lilly W

    You can use the copy activity source tab to mention the wild card file name like DailyImport*.csv.

    Go through https://learn.microsoft.com/en-us/azure/data-factory/connector-sftp?tabs=data-factory#sftp-as-source page, it has examples. If you have questions, feel free to comment to this answer.

    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.