OLEDB Error code: 0x80040E21
<p><a href="http://i.stack.imgur.com/tDQ2I.jpg" rel="nofollow">Screenshot</a>  Hi, I'm executing multiple DMLs in OLEDB Command transformation using flat files source. Having connected the flat file connection manager and OLE DB connection managers and use derived column tranformation to help in getting all the columns from flat files aligned correctly with OLE DB columns, changing the data type, length and code-1252 . These errors occurred. </p>

<p><strong><em>[OLE DB Command [60]] Error: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E21.
An OLE DB record is available.  Source: "Microsoft SQL Server Native Client 11.0"  Hresult: 0x80040E21  Description: "Invalid character value for cast specification".</em></strong></p>

<p><strong><em>[OLE DB Command [60]] Error: There was an error with OLE DB Command.Inputs[OLE DB Command Input].Columns[upt_Gender] on OLE DB Command.Inputs[OLE DB Command Input]. The column status returned was:
 "The value could not be converted because of a potential loss of data.".</em></strong></p>

<p><a href="http://i.stack.imgur.com/T5pRi.jpg" rel="nofollow">screenshot</a></p>