i have a OLE DB SQL Command with a flat file destination and have added to column headers to the flat file but when executing package I get the below issue. is this because I have 2 extra columns in flat file?
Sounds like your package got corrupted. Your best bet is to drop and re-create the flat-file Destination Connection Manager, and then re-add the connection to the Destination.