I was testing using Control Flow to string our integration packages together rather than simply scheduling each package separately. The first time worked, but the most recent time failed on the first parallel component. One package executed, and the other 3 in the Parallel task failed with a result like this:
Package failed: Transaction (Process ID 81) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Is this normal behavior when trying to run in Parallel several replication packages with QBO source and SQL Server destination?
The Control Flow package ID is 213237.
The packages that were trying run in parallel were 212993, 213228, 213229 and 213230.
I would also be open to suggestions for how best to schedule, say, 100 QBO/SQL replication packages and then execute a stored procedure after all those packages have completed.