• I am using a similar SFTP 3rd party application in one of my ODS loading SSIS package.

    The problem is that the error handling is generalized and not specific.

    I suggest searching for dlls that can be called through script task which can pass error messages to package variable which can be included in the sent mail task. You can also compare already downloaded files against your audit table there by avoiding duplicate downloads.