This error is probably occurring because you have a value in your source for one column that is not valid for the same column in the destination.
Continue reading after the "... error code 0xC0202009" and you will find the specific column having no valid values after reading something like ".Inputs[OLE DB Input].Column".
Make sure the destination column can handle the length of the data coming from the source or the number of digits and decimals coming from the source, in case is numeric data.
Hope this is the case.