I am converting data from Oracle Database to SQL Server and during the conversion I have to log the row which is failed and also I need to log the column name whose value caused error. For example, if there are 100 rows in Oracle database out of which 98 rows converted to SQL Server but two rows failed. The reason of the failure is the size of data in a particular column where the size of that column in SQL Server is of 4 but in Oracle the is 5 and there are two records whcih 5 size and those are not converted. This is just a example. I have to convert the data of around 13 tables each having weekly data of 6millions.
Please help me to find out the SQL SSIS custom script to get the column which caused row failure.