I just encountered errorcode -1071607689, which translates to
DTS_E_OLEDBDESTINATIONADAPTERSTATIC_CANTCONVERTVALUE. Not the most helpful error definition. In my case: the data I was trying to insert was larger than the field it was being inserted to. I was trying to insert into a varchar(255), and the data was larger than that.
HTH,
Rick