Friday, March 9, 2012

Multiple data flow tasks in one SSIS package

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?

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.

No comments:

Post a Comment