SSH Connection with key file

[Mykal Aragon]

Hi All,

I'm trying to connect to a client SFTP using a CozyRoc File Transfer Task and an SSH Connection Manager with a key file. I've found that when uploading a file (using the above) I must loop thru the folder that contains the file I am trying to upload, then pass the variable from the foreach loop to the CozyRoc File Transfer Task to have the file uploaded.  This I can live with.

However, when downloading from an SFTP using a CozyRoc File Transfer Task and an SSH Connection Manager with a key file, I am only able to get the download to work running in Visual Studio. When I deploy to SSMS Integration Services, the job fails 99% of the time.  It fails with a message of "Local path is not a file path or you do not have permission to access it".   Thing is, the SQL Agent (MSA account) has access to our network folder. I've also configured the job to pass along a Server Passphrase AND Server Password, just in case those might be part of the issue.

What else might I be missing? Any help is appreciated in getting this download working without issues.

Thanks,

Mykal

[Ivan Peev]

Hi Mykal,

The error you are seeing is returned from the OS. What did you specify for the Local parameter?