This seminar explains how to create SSIS packages and defines the basic objects
contained in the control flow and data flow. Later seminars describe the advanced features,
deployment, and implementation details of SSIS.
Seminar objectives:
Implement control flow.
Implement data flow.
Implement package logic by using variables.
Extend SSIS packages by using .NET code.
Identify and resolve issues related to SSIS solution deployment.
Install and maintain SSIS components.
Step 1: Creating SSIS Packages and Data Sources
Creating SSIS Packages
Developing Project Data Sources and Package Connections
Practice: Creating New Packages, Data Sources, and
Connections
Step 2: Creating and Editing Control Flow Objects
Creating Control Flow Tasks
Using Control Flow Containers
Working with Package Variables
Using the Script Task and Data Profiling Task
Testing Package Execution in BIDS
Practice: Creating and Editing a Control Flow Task
Step 3: Using Data Flow Adapters and Transformations
Defining Data Flow Source Adapters
Creating Data Flow Destinations
Working with Data Flow Transformations
Practice: Creating Simple and Complex Data Flows
Case Scenario: Creating an ETL Solution
Comments