Thanks Jack, I know the problem , ALl the rows where 3rd column which is database timestamp is the problem. the rows where this column is empty is given me the problem. there are 82 rows , out of which 22 rows in flat file have this 3rd row, the rest 60 columns are empty. so what SQL serevr is trying to do is convert this empty string ( I guess so) . when i redirected the rows these empty columns are the ones thats get redirected. when u see in the table all the rows gets loaded when i try ignore on failure.

Another thing here is the column is not empty actually. when i do

select * from table ......

where column 3 is NULL , gives me zero rows and when i do where column3 is not null gives me all rows

Things are different in SSIS, when it comes to NULL.

its converting null values from flat file into empty string.

I can do rediret row, conditional spilt, or derievd column. But my head wants me to load data in the oredr of the flat file........

Thanks....