Multiple data flow tasks in one SSIS package RRS feed

  • Question

  • What are the advantages and disadvantages of having multiple data flow tasks in one SSIS package?


    Is this a good idea at all considering the workflow may be similar now but may change in the future? Should it be left as one data flow per package?

    Wednesday, July 25, 2007 10:36 PM


  • It's up to you and how you like to manage your work.  I like to break my packages into logical units -- each containing as many data flows as required.  You'll want to balance this with maintainability though -- the less in a package, the easier to maintain.
    Wednesday, July 25, 2007 10:42 PM