Post reply

data into new file

  • August 31, 2016 at 3:29 am

    #329756

    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.

  • August 31, 2016 at 5:39 am

    #1898504

    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?

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

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

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