Tuesday, June 9, 2015

Problems when trying to get changed records from...

The SSIS Package was configured to get only the net changes by applying the CDC processing mode as Net in the CDC Source.
But when the SSIS package was executed, got the below error message.
"Problems when trying to get changed records from dbo_testcdc. Reason - Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding..".

The issue was fixed by using the below steps.


  • Right click on the CDC Source and select Properties.
  • In the properties window find the Command Timeout and change it to 0. Default value of this property is 30.
  • Save the package and execute it. It should run without any issue.