sql - Splitting flat file rows to multiple flat files SSIS -

i'm new ssis , i'm having bit of problem splitting csv multiple files row.

i have csv multiple rows - trying split each row new flat file , make each column new line in flat file.

i have flat file source pumping derived column , sorting data format want. test outputted 1 large flat file multiple rows ideally create file each row.

i have tried using each loop through i'm not quite sure how use in ssis.

any appreciated - in advance.

i think don't need loop, c# script trick. blocks defined as:

source -> [rowcounter variable counter] -> [script task] -> destination

script task:

int val = convert.toint32(dts.variables["counter"].value); dts.connections["destinationconnectionname"].connectionstring = "c:\\yourpath\\" + val.tostring() + ".txt"; 

of course have specify readonly parameter: counter.

this set connection name each row. combine sorting, have.