Download files from SFTP and upload them into SQL server

joey1234

How to download files from the SFTP location and upload them to the SQL server, if there is no File found in the SQL server and an error pops up then it should automatically send an email to the user.

Currently, it is set to download to the local desktop, which needs to be changed to the SQL server, and then the error trigger email workflow has to be added to the existing workflow. 

Please help.

MatthewO

@joey1234 it seems like you could use a Dynamic Input tool to read file after it is downloaded with the Download Tool. Then, you could connect an Output Data tool to write the file contents to SQL Server.