After working through the task above many times, the problem (I think) ended up being a bad column value within the table I was looping through.
Still new to SSIS and not sure why I could not see any error logging for this. It would have made the debugging easier..
The solution is just as I have outlined above.