I'm putting this here so that I don't forget where to look for it later when I need it as it has already happened in the past. Mike has a great post which is full of links to other great posts on the topic.

"... It seems that the DTS/SSIS package BAM_DM_<activity name> should be moving it into the Instance and Relationship tables in the BAM Archive database but it doesn’t." The BAM Data Maintenance DTS/SSIS package will only move data that is out...