Wednesday, December 31, 2008

More SSIS Error Codes: -1071607689 1071607689

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