How to check SQL Data tables Row Count and need to apply condition if <1000 rows

Need help to find out rows count from SQL Query.

Process Flow:

  • Get the data from SQL and export into Excel file with naming convention.
  • Check if there is <1000 rows then need to retry SQL query and if not then need to export in


Hope you are using Execute Query activity to retrieve the data from Database.

If yes then it will give output as DataTable. Let’s say dtOutput. And then you can check row count as below.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.