ETL may stop responding if the query has to retrieve large result sets

[CR #540683] Reinitializing the DB Data Provider Full Load component may cause ETL Development to intermittently stop responding, if you are running a query to retrieve records from a table containing large number or rows. This may also cause Sybase ETL Server to run out of virtual memory due to excessive memory consumption.

Workaround: Select “Use Cursors” when you configure the ODBC data source for Adaptive Server.