I am using CDATA SFTP control flow CDATA-sftp-download procedure to download all the files from SFTP server to sql server , its working fine when the files are available on SFTP server but getting error unable to populate result columns for single row type, query returned a empty set when trying to execute the when the files are not present on server.
Any idea how to solve this error.
Thanks,