Seems working for me, but i'm not very sure where are the circumstances.
- Double click the destination node to open the Destination Editor (In my case it's OLE DB)
- There are 'Error Output' at the left side, click it
- Below the 'Error' column, just change from 'Fail component' to 'ignore failure'
- you're done.
Yet, again, it works, but doesn't solve the problem with the execution, but at least solve your problem especially if u're students, haha