The source file format in CSV, lets assume it has following data
id name marks
1 a 100
2 b 90
I have created flat file connection manager to read the source file and I have created a table with ID and Marks column and mapped in OLE DB mapping, though when I run the package, it loads id and name values instead of id and marks data.