I have an XML Source file w/XSD, Data Conversion, and SQL Server Destination
using OLE DB.
All fields, columns are set up correctly & matching to what's in database.
I get an Error on the SQL Server Destination task in the 'ProcessInput
method' (wish i could look at that!!!), and get the following error message.

[SQL Server Destination [8404]] Error: An OLE DB error has occurred. Error
code: 0x80040E57. An OLE DB record is available. Source: "Microsoft SQL
Native Client" Hresult: 0x80040E57 Description: "The statement has been
terminated.". An OLE DB record is available. Source: "Microsoft SQL Native
Client" Hresult: 0x80040E57 Description: "String or binary data would be
truncated.".

[DTS.Pipeline] Error: The ProcessInput method on component "SQL Server
Destination" (8404) failed with error code 0xC02092B5. The identified
component returned an error from the ProcessInput method. The error is
specific to the component, but the error is fatal and will cause the Data
Flow task to stop running.

At this point, I need some help.
What is Error Code 0xC02092B5 ?
I have checked the xml for values that are too long and would be truncated.
They are the correct size.

Wha happen???? Please help. Thx in adv.
--
Sami Majed Abbushi