Post reply

In SSIS Parallelisum or batch run

  • October 10, 2013 at 11:05 pm

    #147987

    In SSIS, if I have to load multiple file to sql server, I can do using ForEach loop container(which is sequence process). But If I have 500 files, than in SSIS how can I implement parallelisum or batch run.

  • October 10, 2013 at 11:59 pm

    #1657789

    Hi,

    If you are using for-each then sequential process is unavoidable.

    I have 2 solutions for you,

    1. If you have several types of files(*.xls,*.txt, *csv) then you may have that much number of Foreach containers and direct them to process a specific type

    2. You can 3 or 4 folders say Part1, part2, part3... and tell your 3 different Foreach loops to look at a specific folder. Probably for this its better to separate files based on size into each of those folders.

    I'll post other ideas if I could think of any.

    Regards,

    Suresh

  • October 11, 2013 at 7:21 am

    #1657899

    Thank you sir, it does make sence.

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

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