question

Hello all, I need to create a process in SSIS that will do the following things per each csv file separately. Each file has a different number of columns and different data types, so I need to come up with a generic solution. So, in a nutshell: 1. Check each file's number of columns and data type. 2. Apply sanity checks to each column. For example, integer should not have (.). 3. As a final outcome, the file will contain all the rows and two additional columns, errorcolumns and errordescription for example: Column1 Column2 Column3 Column4 Column5 Column6 ErrorColumns ErrorDescription 500 800 Test1 Test2 200.8 1/6/2017 80 Test3 Test8 10,2 Column2|Column3|Column4|Column5|Column6 Null|not int|not int|not float|null Could you please help me? Thank you in advance.