question

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

ADF SFTP Source Returns Error Please check if the path exists. If the path you configured does not start with '/', note it is a relative path under the given user's default folder

Hi I'm getting the following error....SFTP is Source (not sink). SINK is Azure SQL DB Table. Files are in XML format.

GET METADATA works fine if I do WildCard like ASN to find list of files when I do for loop and pass each file name in the COPY Activity (Source)

ErrorCode=SftpPathNotFound,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Can't find SFTP path '/Receive/INX_XXXXXXXX_ASN_20210728012200817116546932367669276.xml'. Please check if the path exists. If the path you configured does not start with '/', note it is a relative path under the given user's default folder ''.,Source=Microsoft.DataTransfer.ClientLibrary.SftpConnector,''Type=Renci.SshNet.Common.SftpPathNotFoundException,Message=/opt/apps/uprd1bpn1/bpfs2/2021/July/0209/04/22/25565817aec33de9cnode2_WF128489406.dat (No such file or directory),Source=Renci.SshNet,'

Any ideas?

azure-data-factory
· 5
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 @Sqlnathan and welcome to Microsoft Q&A.

Could you clarify what ASN is or stands for??

Also, is the problem in the running of Get Metadata or of Copy Activity?

Are you trying to copy one file, or many files one at a time, or many at once?

The message is saying it can't find the file. Could there be a typo?

0 Votes 0 ·

ASN is a name of the filetype. (Advance Shipping Notice) we are trying to download three kinds of file types from the SFTP which has three different Structures. one is ASN type.

MetaData Activity works fine. It returns all the files with ASN in the file name then inside the for loop I have a copy activity which I'm passing the filename and trying to download the content of the XML file that's when I get the error.

We are using Auto Resolve Integration Run Time.

0 Votes 0 ·

I also tried to hard code the file name after Browsing the folder and pick a file name it still fails.

0 Votes 0 ·
Show more comments

0 Answers