Retrieve large number of rows in collection through SQL

Hi All,

I am trying to fetch a large number of rows into Blueprism collection through SQL. The issue is, it is able to retrieve the rows(somewhere around 50,000) but it starts giving error right after. My motive is to filter it and then write this collection into an Excel file. Please let me know if there is a solution for this issue.
 

Mikkora

New Member
Why don't you filter the SQL query in the first place? Use Data - SQL Server - VBO to open the connection, and execute SQL query to get needed data. It is more efficient.
 
Top