1 / 6

Understanding SSIS Control Flows

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

karma
Download Presentation

Understanding SSIS Control Flows

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Understanding SSIS Control Flows Bret Stateham Training Manager Vortex Learning Solutions bstateham@vortexls.com blogs.netconnex.com

  2. 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

  3. Comments & Questions • Please hold “Can I ….” & “How would I…” questions until the end • Send me an email with follow up questions:bstateham@vortexls.com

  4. Do It!

  5. 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

  6. 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

More Related