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.



Professional SQL Server 2005 Integration Services
Wireless Java : Developing with Java 2, Micro Edition
ISBN: 189311550X
EAN: 2147483647
Year: 2006
Pages: 182

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net