60 likes | 190 Views
Understanding SSIS Data Flows. Bret Stateham Training Manager Vortex Learning Solutions bstateham@vortexls.com blogs.netconnex.com. Agenda. ETL Overview Data Flow vs. Other Data Tasks Data Sources Data Destinations Data Paths Transformations Data Viewers Error Output.
E N D
Understanding SSIS Data Flows Bret Stateham Training Manager Vortex Learning Solutions bstateham@vortexls.com blogs.netconnex.com
Agenda • ETL Overview • Data Flow vs. Other Data Tasks • Data Sources • Data Destinations • Data Paths • Transformations • Data Viewers • Error Output
Comments & Questions • Please hold “Can I ….” & “How would I…” questions until the end • Send me an email with follow up questions:bstateham@vortexls.com
Summary • ETL Overview • Data Flow vs. Other Data Tasks • Data Sources • Data Destinations • Data Paths • Transformations • Data Viewers • Error Output
Thanks! • Send Emails to:bstateham@vortexls.comblogs.netconnex.com • Today’s Sessions: • What’s New is SSIS with SQL Server 2008 (next) • Tomorrow’s Sessions: • Extending SQL Server Integration Services (SSIS) – 9:00am • Understanding SQL 2008 Change Data Capture – 10:15am