Requirements:
- Source and destination system impact
- Processing time windows and performance
- Destination system state consistency
- Hard and soft exception handling and restartability needs
- Environment architecture model, distributed hardware, or scaled-up servers
- Solution architecture requirements, such as ?exibility of change or OEM targeted solutions
- Modular and con?gurable solution needs
- Manageability and administration requirements
Data Flow Design Practices
- Limit synchronous processes.
- Monitor the memory use of blocking and semi-blocking transformations.
- Reduce staging and disk I/O.
- Reduce reliance on an RDBMS.
Leveraging the Data Flow
Data Integration and Correlation
Data Cleansing and Transformation
SSIS ->> Data Flow Design And Tuning
原文：http://www.cnblogs.com/jenrrychen/p/4744988.html
