Adding of sFTP parameters during sFTP using datafactory

Chand, Anupam SBOBNG-ITA/RX 461 Reputation points
2022-04-21T01:21:27.647+00:00

We are connecting to a sFTP server belonging to one of our vendors using the Data factory sFTP connectors. The server has some defaults that only 250 files can be seen at a time using the preview mode. We've been told to include a "maxlist=500" parameter during the sFTP 'ls' command.
Now this may have been possible using a normal sFTP server but is there a way to include such sFTP parameters while using the datafactory sFTP connector?

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

1 answer

Sort by: Most helpful
  1. ShaikMaheer-MSFT 38,401 Reputation points Microsoft Employee
    2022-04-22T14:58:25.453+00:00

    Hi @Chand, Anupam SBOBNG-ITA/RX ,

    Thank you for posting query in Microsoft Q&A Platform.

    Do you want to try listing down file or folder names from a directory using ADF? If yes, GetMetaData activity can do that task. In GetMetaData activity under field list we need to choose child Items option.
    195636-image.png

    Executing some commands using activity may not possible in ADF. But the requirement which we are trying to achieve using commands can be implemented by leveraging activities in ADF. Please let us know your requirement with simple example if need more discussion on this.

    Please let us know how it goes. Thank you.