Hi All,<o:p></o:p> I designed SSIS package for loading data from Sql server to Sql server Destination table. While loading data from source to Destination need to check is there any mismatch of datatype.If any mismatch in data type need to redirect thse records to error table.<o:p></o:p> In error table I need to store datatype mismatched column name and datatype of that column.<o:p></o:p> Can you please help on this to resolve this issue.<o:p></o:p>Regards, Praveen

You need to configure the error output on the sql destination. Check this for a stepwise guide from Reza on how to do it. Once you have done that SSIS adds error code and errorcolumn as two new columns to the error output (mind you error column is the lineage id of the errored column and not its name). Check this on how on how to get the error column name. You can also use this codeplex component which gets you the error column name. Now about the datatype of the column, I think you will be better off getting the error description instead of the data type because a) its simpler b) its descriptive i.e. if there is a data cast failure your error description will read "Failed to convert from DataType1 to DataType2 for column xxx". Check this on how to get the error description. http://btsbee.wordpress.com/