Post reply

SSIS Parallel Processing

  • March 16, 2010 at 11:11 pm

    #139419

    I have to modify an existing package to enable parallel processing (multi threading) package currently processes flat files and dumps them over I need to enable process where it processes multple flat files at the same time

    what are the different ways to achieve that

  • March 17, 2010 at 7:40 am

    #1135224

    You could place different data flows in one single sequence container. Each dataflow reads a file and processes it.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • July 26, 2010 at 9:30 am

    #1198260

    WangcChiKaBastar (3/16/2010)

    I have to modify an existing package to enable parallel processing (multi threading) package currently processes flat files and dumps them over I need to enable process where it processes multple flat files at the same time

    what are the different ways to achieve that

    If you can use third-party solutions, check the commercial CozyRoc Parallel Loop Task. It can execute standard SSIS loop container concurrently, utilizing all your server processing resources. In tests, a CPU intensive sequential process when executed in parallel on 4-core machine was executed 3 times faster compared to the sequential. Cheers!

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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

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