title: Can an SSIS script component send more than 25,000 rows at a time?
body: <p>We have several SSIS packages that sync records from Microsoft AX to our warehouse management system, we use a script component in it that calls a query service within AX to get the records and then we insert them into our target table in SSMS. On a single run it will grab 25000 exactly and send those over, is there a way to increase how many it will send over in a single run? We didn't set this 25000 limit it's just something we've always seen happen with any of them that are trying to send more than that.</p>