Timeout in SSIS package running DBCC CHECKDB

Question

I have created an SSIS package to run DBCC CHECKDB on all the databases on the server and send error messages by email.

But for several of the databases, I get an exception running my script:

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

The only timeout I can find in the project/package is set to 0, which I presume means no timeout.

DBCC CHECKDB runs from SSMS just fine.

Morten Nilsen · Accepted Answer · 2016-01-12 10:35:23Z

1

As it turns out, there is a CommandTimeout property on the SqlCommand object.

answered Jan 12, 2016 at 10:35

Morten Nilsen

1434 bronze badges

1 Answer 1