data into new file

  • 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.

  • coool_sweet (8/31/2016)


    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.

    Is the data coming out of SQL Server?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply