70 likes | 231 Views
Understanding SSIS Control Flows. Bret Stateham Training Manager Vortex Learning Solutions bstateham@vortexls.com blogs.netconnex.com. Agenda. Business Intelligence Development Studio Control Flow Over View Connection Managers Using the Execute SQL Task Using the Script Task
E N D
Understanding SSIS Control Flows Bret Stateham Training Manager Vortex Learning Solutions bstateham@vortexls.com blogs.netconnex.com
Agenda • Business Intelligence Development Studio • Control Flow Over View • Connection Managers • Using the Execute SQL Task • Using the Script Task • Working with Variables • Working with Precedence Constraints • Using Loop Containers • Logging and Error Handling
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 • Business Intelligence Development Studio • Control Flow Over View • Connection Managers • Using the Execute SQL Task • Using the Script Task • Working with Variables • Working with Precedence Constraints • Using Loop Containers • Logging and Error Handling
Thanks! • Stay in touch:bstateham@vortexls.comblogs.netconnex.com • Today’s Sessions: • Understanding SSIS Data Flows (next) • What’s New is SSIS with SQL Server 2008 (4:00pm) • Tomorrow’s Sessions: • Extending SQL Server Integration Services (SSIS) – 9:00am • Understanding SQL 2008 Change Data Capture – 10:15am