er.mayankshukla (1/16/2016)
The "ADO NET Source" failed because truncation occurred, and the truncation row disposition on "ADO NET Source.Outputs[ADO NET Source Output].Columns[U_OrderName]" specifies failure on truncation.
It says that there is a truncation error, where the destination column length is less than the source, can you check column U_OrderName
I double-checked the column length. In Management Studio the column is shown as U_OrderName (nvarchar(20), null). When I edit the SISS package the Advanced Editor for ADO NET Source show the U_OrderName length as 20. The Advanced Editor for OLE DB destination shows the length as 20.