[SQL Server] Internal Timeout Of SQL Queries

[Anonymous]

We're working with a database that takes up to 2 minutes to respond with results. Blue Prism seem to throw a timeout exception after 30 seconds. I need to be able to override this behavior. Anyone with any input on this very specific problem?

[John__Carter]

You might need to use a bespoke connection string that specifies a higher timeout value. On the Set Connection page of the SQL utility object you'll see Calculation stages where the connection string is constructed. Try experimenting with appending ;Connection Timeout=180