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,
Hi
The error message "Unable to populate result columns for single row result type. The query returned an empty result set." is not an error thrown by our product but it is thrown directly by SSIS instead. This is an expected behavior and occurs because the CData SFTP Task expects the result to be returned in a row when you are setting the ResultSet to SingleRow, however in the case you don't have any files available in your remote server no records will be returned if you run the package, hence the error.
You might find the following thread useful:
Feel free to reach out to our support team at [email protected] if you have any other questions.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.