////

use DATA CONVERSION tool in the dataflow task

its like our script component look for the serial no then look for the subseq no then output the highest subseqno row of that serial number.

Please help me out

india,1,987

unitedstates,2,987

uk,1,723

australia,2,723

pakistan,3,723

if you look at the above data, i need the last record in that serial no

like

india, 1 , 987

unitedstates, 2 , 987

so according to above discussion i need unitedstates,2,987

uk,1,723

australia,2,723

pakistan,3,723

for...

Hi Old hand you are exactly correct I have un even columns

I would appreciate if you could send me the script

I need to seperate each every column

so column delimiter is ","

so i need some script to seperate each every column.

and some columns are null for some rows

so i need...