I applied this solution but it keeps on changing the warning from souce to destination and back and forth.

Here is my issue and it just keep on torturing me.

My source is CSV and I have one column that has length of 50

My destination is OLE DB, and there; that column's length is 15

I have to set the error as ignore and process shows Green but table is empty.

I set the coulm to 15 at source (csv) and warning switches from destination to Source

I do the refresh and warning comes back to destination