If a CranPort or Assemble package, created from Collect / DataGarage is timing out, the following steps can resolve this quickly.
- Update the default timeout in CranPort / Assemble Parameters (tablename: CranPort.dbo.CPParam) to 1200 or greater. This will affect all packages that have a NULL Timeout setting on their vertical.
Update DataSource connection and command timeouts. Make sure absolutely none are NULL or 0. For the ones related to the packages that are failing increase the Command Timeout to anything from 300 on up until the package works. Setting it to 1200 as recommended for the default package timeout above should work for larger tables.
If you still get failures you can try lowering the Batch Size (say to 1000 or 5000).