in my ssis package , i have 6000 rows coming and i am puttingin 1 file.
now my requirement is if more than 6000 comes, ex 8000 , 6000 will go in one file and 2000 in another file.
so in one file i can put max 6000.
i can do it with script task,but without it how can i do that ssis create second ,third file on its own.