Let's check the log:
Doesn't mean much to me. But there is a strange thing is in the first picture: there is a row being rejected, but there were no rows fetched from the source. It seems that if you don't have any input for an XML Generator transformation, it will try to create XML nevertheless. And it will result in the strange error if one of the input fields is of datetime type. Since there is no input at all, it tries to convert [0000-00-00] to date.
