[Fix] - Error Codes - 1071607685 DTS_E_OLEDBDESTINATIONADAPTERSTATIC_UNAVAILABLE

Wikitechy | 4571 Views | sql server | 08 Jun 2016

 

Error Code: -1071607685

Name: DTS_E_OLEDBDESTINATIONADAPTERSTATIC_UNAVAILABLE

Scenario :

  • The error arises due to the constraint violation or improper setting in the Data Flow Task. 

Error Code:  -1071607683 

Name: DTS_E_OLEDBDESTINATIONADAPTERSTATIC_INTEGRITYVIOLATION) 

Reason :

  • This error occurs due to the foreign key constraint.

Fix 1 : 

  • The error needs a fix on SSIS batch size and the fast load options. 

1.Modify the value of 

  • SSIS package ->Data Flow Task-> Properties -> DefaultBufferMaxRows From 10,000 to 1 as shown below:


2.Change the Data access mode on the OleDBDesination_SQL 

From “OpenRowset Using FastLoad” to “OpenRowset”. 


  • Now work on the package with fresh tables to find that the error is resolved. 

Fix 2 :

  • The error occurs due to a row with defect value in the batch during a Data Flow task with fast load option using Maximum Insert.
  • Identify the problematic rows back and remove from the table.

Fix 3 : 

  • SQL Server service pack is required to resolve the problem.

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 Error Tags :

  • Integration Services Error and Message Reference
  • SSIS - ErrorCode column
  • Getting Error Column Name in SSIS
  • sql server - SSIS Error Code 
  • SQL Server SSIS Packaage Error Code 1073741819
  • Adding the error column name to an error output
  • SQL Server SSIS  Error Code 1071607685



Workshop

Bug Bounty
IOT Hackathon
Webinar

Join our Community

Advertise