>If the Error Source says it is the SQL OLE provider can I rely on that to mean that the error was generated after it left my DTS package?

You'll probably find that that's the case.

> And if so, is there a technical reference for the SQL provider?

There's probably one somewhere. Usually the error can be traced back to a SQL Server error message.

-Mike