[Fix] - Error Codes - 1071607685 DTS_E_OLEDBDESTINATIONADAPTERSTATIC_UNAVAILABLE
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 7.0 OLAP Tools
- SQL Server 2000 64-bit Edition
Related Error Tags :
- Integration Services Error and Message Reference
- 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