# CDATA SFTP Driver **URL:** \ **Category:** CData Drivers\ **Tags:** question, file-transfer, cdata-sftp, control-flow, error\ **Created:** [June 20, 2024, 2:15pm UTC](https://community.cdata.com/t/cdata-sftp-driver/792 "2024-06-20T14:15:17Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![PravallikaM](https://avatars.discourse-cdn.com/v4/letter/p/839c29/32.png) [@PravallikaM](https://community.cdata.com/u/PravallikaM)\ **Post date:** [June 20, 2024, 2:16pm UTC](https://community.cdata.com/t/cdata-sftp-driver/792/1 "2024-06-20T14:16:17Z")
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, ---
**Author:** ![Ethem\_Q](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/ethem_q/32/1997_2.png) [@Ethem\_Q](https://community.cdata.com/u/Ethem_Q)\ **Post date:** [June 24, 2024, 9:51pm UTC](https://community.cdata.com/t/cdata-sftp-driver/792/2 "2024-06-24T21:51:03Z")
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](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](mailto:support@cdata.com) if you have any other questions.