Solved

CDATA SFTP Driver

  • 20 June 2024
  • 1 reply
  • 25 views

Badge

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,

icon

Best answer by Ethem Q 24 June 2024, 23:51

View original

1 reply

Userlevel 5
Badge

Hi @PravallikaM 

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:

https://stackoverflow.com/questions/30663584/ssis-execute-sql-task-stored-procedure-returning-empty-result-sets 

Feel free to reach out to our support team at support@cdata.com if you have any other questions.

Reply