Hopefully others can learn from this ...
I spent the better part of Friday and Today troubleshooting an INSERT statement from a SQL Server 2005 box to our IBM DB2/AS400 system.
Problem:
OLE/DB provider returned message: A SQL error has occurred. Please consult the documentation for your specific DB2 version for a description of the associated Native Error and SQL State. SQLSTATE: 55019, SQLCODE: -7008
Solution:
If you are trying to do the INSERT from a Microsoft SQL Server Linked Server, you must enable journaling.
Reference:
http://support.microsoft.com/kb/286464
I checked with the DB2/AS400 folk on the other side of the fence, and they informed me that journaling is off by default for DB2/AS400 objects. I requested that journaling be enabled for my destination object and I was able to INSERT data via my Linked Server.
Happy SQL'ing!
Regards,
"Key"
MCITP: DBA, MCSE, MCTS: SQL 2005, OCP