haichells (10/14/2016)
In "Show Advanced Editor" of a OLE DB Source i see Input/Output Columns tab where each column's data type was listing as per the database type and length. And the Same source has been mapped to a Flat file. Don't we have an option to generate a report to find the mismatch in columns datatype/ length?
There is no 'report' option.
Are you worried about the data types in 'External Columns' (database) being different from those in Output Columns (SSIS pipeline to output file)? If you create a new flat file connection manager and connect it to your source, the output columns will automatically be generated with the same data types.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.