Multiple data flow tasks or Multiple OLEDB source and Destination in One data flow task? RRS feed

  • Question

  • Hi, i am simply moving data from 5 different tables to their corresponding 5 seperate destinations.

    can somebody tell me which is a good practice, having just one data flow task and have 5 OLEDB sources and Destinations

    OR having 5 seperate data flow tasks?

    I know both works but just wanna know which one's a good practice.


    Monday, January 23, 2012 8:29 PM


  • I advocate using multiple FDTs to avoid contention
    Arthur My Blog
    • Marked as answer by JoJo_1 Monday, January 23, 2012 10:58 PM
    Monday, January 23, 2012 8:35 PM