• 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