Timeout in SSIS package running DBCC CHECKDB

Posted on

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.

Answer :

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

Leave a Reply

Your email address will not be published. Required fields are marked *