what is Unspecified error in ssis

I had a similar issue today and non of the internet posts worked for me. The error I was getting to is similar to yours. I'm posting in case someone else has the same problem

Error: 0xC0202009 at Get fresh data, OLE DB Destination [2]: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available.  Source: "Microsoft SQL Server Native Client 11.0"  Hresult: 0x80004005  Description: "Unspecified error".
Error: 0xC0209029 at Get fresh data, OLE DB Destination [2]: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR.  The "OLE DB Destination.Inputs[OLE DB Destination Input]" failed because error code 0xC020907B occurred, and the error row disposition on "OLE DB Destination.Inputs[OLE DB Destination Input]" specifies failure on error. An error occurred on the specified object of the specified component.  There may be error messages posted before this with more information about the failure.
Error: 0xC0047022 at Get fresh data, SSIS.Pipeline: SSIS Error Code DTS_E_PROCESSINPUTFAILED.  The ProcessInput method on component "OLE DB Destination" (2) failed with error code 0xC0209029 while processing input "OLE DB Destination Input" (15). 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.  There may be error messages posted before this with more information about the failure.

This was happening when doing an OLE DB transfer from one table to another. The problem was with the destination's table index

Tried to drill down on a particular record that was giving the problem and identified which fields were giving the problems. I managed to do through a number of trial and errors. By amending the source sql query to select different fields, until I found out which field(s) were giving me the insert problems.

Then deleted any associated indexes on that particular destination and it worked