Thursday, October 18, 2007

Error Codes -1071607685 ((DTS_E_OLEDBDESTINATIONADAPTERSTATIC_UNAVAILABLE)) and -1071607683 (DTS_E_OLEDBDESTINATIONADAPTERSTATIC_INTEGRITYVIOLATION)

This is about Error Codes -1071607685 (DTS_E_OLEDBDESTINATIONADAPTERSTATIC_UNAVAILABLE) and -1071607683 (
DTS_E_OLEDBDESTINATIONADAPTERSTATIC_INTEGRITYVIOLATION).

These 2 codes in my experience are actually the same. I got the first while I had the Fast Load option enabled in an OLE DB Destination. I opened it and changed the Data access mode to Table or View (from Table or View - Fast Load), and then received the second error, which is actually descriptive.
The second error,
-1071607683 (DTS_E_OLEDBDESTINATIONADAPTERSTATIC_INTEGRITYVIOLATION) was caused by a foreign key constraint.

Hope this helps someone,
Rick

7 comments:

Anonymous said...

Interesting to know.

Francisco Boerr said...

you help me a lot!!! i've been working 45 mins without solving it! tks!!!

Anonymous said...

Yes I was another someone you helped!
Thanks!

Anonymous said...

+1

Anonymous said...

You can also decrease the default setting "Maximum insert commit size: 2147483647" to keep the batch small. It will slow the load process but your job won't fail as a whole. Only the batch that has validation error will be rejected.

Anonymous said...

Very helpful dude thanks, you have saved me a lot of time :) Cheers

Anonymous said...

Thank you for your Help !


For any operaion using Fast Load, if any one row fails the constraints, then the entire batch is rejected, kind of like a BULK INSERT. Without Fast Load, you have the option to re-direct bad rows to another (Error) flow and deal with them differently, like sent them to a flat file for analysis.