In SSIS i have dataflow task which transforming data from flatfile to SQL table. But sometime flatfile is coming with invalid column name. Still transformation getting completed with no errors as i defined data type nvarchar(4000) for all columns. Is there anyway ssis can recognize source flat file column names and throw error messageif column name not matches.