This took me a little time to figure out, but I thought it might help others. Here is the error I received:
[OLE DB Destination ] 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 10.0" Hresult: 0x80040E21 Description: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".
[OLE DB Destination ] Error: Cannot create an OLE DB accessor. Verify that the column metadata is valid.
The important part is the bold,italic,underlined section. You might spend quite a bit of time looking at your metadata and trying to figure out what is wrong with it and the problem is your destination, not your source. The error was on the destination object and it turned out I had a source column with a datatype of text, with a destination data type of varchar(1000). I simply had to change the destination type to varchar(MAX).