Welcome to the Orange County SQL Server Professionals User Group
Our Next Meeting: Thursday February 4, 2010
6:30PM, New Horizons, Anaheim
Topic: SQL Server Integration Services Control Flows and Data Flows
Presenter: Bret Stateham
|
|
Presenter Bio:
Bret has over 20 years of experience in the IT field, over a decade of experience as a trainer. He has been working with Microsoft platforms since the early '90s.
Bret's focus is on SQL Server solutions and is an expert in .Net development as well as SharePoint implementation, configuration and administration.
Bret is a published author, and a frequent speaker at regional Code Camps and user group meetings.
Session Summary:
In this session we will cover the specifics of SQL Server Integration Services Control Flows and Data Flows.
Control flow is where SSIS developers manage the sequencing of tasks within an SSIS package. Control Flow concepts covered in this session include tasks, precedence constraints, containers, variables and more. Understanding the core concepts of control flow is the foundation of creating effective SSIS Packages.
In this session we will also focus on a specific SSIS task: The "Data Flow" task. The data flow is the most commonly used tool to move data in an SSIS package. It is in the data flow that you specify the data sources, transformations, and destinations for your data movement process. Data Flow concepts covered in this session include Connection Managers, Data Sources, Data Destinations, Transformations, Error Output, and more.
|
|