How to Skip row where column value character lenght is more than 50 char

[amtkmr1990]

i loading a file data to ms sql db. 

some times the value of a a row is too long char. How can skip this row and let other rows to enter. 

I have also unchecked the die on error box.  

example 

name, value, store

item1,44,AC

asdnonasc238712847kcnn,44,GH  <-------- ignore this row  from insert 

item3,67,FD

[manodwhb · Accepted solution]

@amtkmr1990 ,you can use below way.

StringHandling.LEN(row2.ename)<=50

[amtkmr1990]

Thanks, I will try it.

And hwo to display or mail the skip rows ?.

[manodwhb]

@amtkmr1990 , you can catch the output rejects by using below way and can write to a file or DB or tLogRow, 

[amtkmr1990]

do i ned to uncheck or check the "Die on error " box of mssqloutoput ?

[manodwhb]

@amtkmr1990 no need to uncheck and the same error should not come on the same field.