Post reply

Performance - Multiple data flow task

  • October 23, 2008 at 4:35 pm

    #128085

    Hi,

    I am having 16 source and destination tables. Each table contains millions of records. I Created a SSIS package to transfer the data from source to destination, which has 16 dataflow task. My question is

    Do i need to have separate data flow for each transformation or i can go for one or two data flow task? Which will be a better performance?

    Also i created 3 connections even though the source and destination is same. All i am doing this is for better performance.

    Please let me know my package is correct or i need to modify my package to get better performance.

    Thank you,

    Ahamed.

  • October 24, 2008 at 2:14 am

    #889060

    Hi,

    I tested this 6 months ago, I had to import 12 files into the same destination but different tables. Running these in paralell on a 8 core machine with 16GB RAM increased speed up to 80% compared to importing them consecutively.

    Regards,

    Jan

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

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