Thanks for your help. This worked after I changed the source dataset; SQL database. I think there is some weird behavior with Oracle database.
The preceding copy activity was against an Oracle database so I kept the log activity against the same source. When I changed the source to a SQL database it worked