SQL Error when using DM step type "Copy Data" to move archive data between Scenarios

Hi, I've been using a data management step (part of an archival sequence) to copy data between Scenarios and archive data. It has worked well in the past but now I'm getting below error when I run t...