[fix]-SSIS Error Codes -1071607689
Scenario :
- Moving data from a flat file source such as excel to database with SSIS Package.
Error :
errorcode -1071607689, which translates to DTS_E_OLEDBDESTINATIONADAPTERSTATIC_CANTCONVERTVALUE.
Reason for the error :
- The reason is that the typecasting occurs with invalid or lengthy data from flat file source into a db field which is really small in size.
Fix :
- The data for insert was larger than the field size defined in DB. For instance, a 400 characters’ data is being inserted into a varchar column with length 255. This causes the error. Increase the field size in DB to accommodate the complete data that is received.
Applies to sqlserver version :
- SQL Server 7.0 OLAP Tools
- SQL Server 2000 64-bit Edition
Related Errors :
- SSIS - ErrorCode column in source table causes duplicate ErrorCode
- sql server - SSIS Error Code -1073741819
- SQL Server SSIS Packaage Error Code 1073741819
- SSIS Error Code -1073741819