3.5. Data Flow Task
If you are familiar with SQL Server 2000 DTS, you won't recognize the Data Flow task in SSIS, as it is a very specialized task in SSIS and is treated differently than the other tasks. This is generally how you're going to insert data into your target system. It's such a large task that most of the next chapter is dedicated to it. The largest improvement is that you don't have to create staging tables to perform common tasks such as aggregating data. Instead, all of this can be done in-memory.
Get Professional SQL Server™ 2005 Integration Services now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
