I cannot find duplicates in the source, therefore I am trying to find another cause for the duplicates. But what I also want to find out with this post is the possible side effects of using manual transactions and a single connection manager for this SSIS pattern.