[fix]-SSIS Error Codes -1071607689

Wikitechy | 5609 Views | sql server | 08 Jun 2016

 

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 1.1 (16 bit)
  • SQL Server 4.2A (16 bit)
  • SQL Server 4.2B (16 bit)
  • SQL Server 4.21a
  • SQL Server 6.0
  • SQL Server 6.5
  • SQL Server 7.0
  • SQL Server 7.0 OLAP Tools
  • SQL Server 2000
  • SQL Server 2000 64-bit Edition
  • SQL Server 2005
  • SQL Server 2008
  • Azure SQL DB
  • SQL Server 2008 R2
  • SQL Server 2012
  • SQL Server 2014
  • SQL Server 2016

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



Workshop

Bug Bounty
IOT Hackathon
Webinar

Join our Community

Advertise