We are saving mapping in below format. The other approach is saving it in vertical format.
File NameCol1Col2Col3Col4
File 1.xlsField1Field2Field3Field4
File 2.csvField1Field3Field2Field4
File 3.xlsField4Field3Field2Field1
File 4.tabField2Field4Field3Field1
The only constraint we faced here is using mapping how to achieve it through SSIS?
Abhijit - http://abhijitmore.wordpress.com