1

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.

1

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.