How does SSIS work?

SSIS is a replacement product to SQL 2000 DTS. New archutecture and design. I have tried to give a summary explaining how SSIS works :

• All data is loaded in tabular form into a memory buffer.
• Data sources can be diverse, including custom or scripted adapters.
• Transformation components shape and modify data in many ways.
• Data is routed by rules or error conditions for cleansing and conforming.
• Flows can be as complex as your business rules, but highly concurrent.
• Finally data can be loaded in parallel to many varied destinations. As far as possible no copying of data (even in memory)

All in all more memory you have the better it is for performance of SSIS.

Thanks
Sutha