question

DharmanDave avatar image
DharmanDave asked

How to retrieve the list of files in an SFTP directory using SSIS ?

I currently have access to an SFTP directory, where new files are uploaded periodically. Old files are not deleted. In my database, I have a list of processed files in a table. Now, when i invoke the process the next time, I need to compare the list of files present in the SFTP directory with the list of file names present in my table, and download only the files from SFTP which have not been processed yet. What is the best way to determine the list of unprocessed files ?
ssissftp
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
sp_lock avatar image
sp_lock answered
Personally I have used the [CozyRoc][1] task for SFTP. It has a responsible price tag if you are going to use in a live env. [1]: http://www.cozyroc.com/ssis/sftp-task
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.