The Data Access Activity becomes timeout in 30 seconds. Is it possible to change the timeout setting?
This is by design and the timeout of database query of Data Access Activity cannot be increased from the 30 second.
The recommendation is to optimize the query and/or examine the database for efficiency.
The following enhancement request was submitted to increase SQL timeout when using Data Access Activity.
Enhancement Request 1493570:Ability to increase SQL timeout when using DAS
If you have a requirement for the large result set and your SQL takes more than 30 seconds you could create a custom dll which calls the SQL and in your custom dll overwrite the 30 second timeout (in custom code).