Before You BeginLesson 1: SSIS VariablesSystem and User VariablesVariable Data TypesVariable ScopeProperty ParameterizationPractice: Creating a User Variable and Parameterizing a TaskLesson SummaryLesson ReviewLesson 2: Connection Managers, Tasks, and Precedence Constraint ExpressionsExpressionsProperty ExpressionsPrecedence Constraint ExpressionsPractice: Using Expressions to Parameterize SSIS ObjectsLesson SummaryLesson ReviewLesson 3: Using a Master Package for Advanced Control FlowSeparating Workloads, Purposes, and ObjectivesHarmonizing Workflow and ConfigurationThe Execute Package TaskThe Execute SQL Server Agent Job TaskThe Execute Process TaskPractice: Creating and Configuring a Master PackageLesson SummaryLesson ReviewCase ScenariosCase Scenario 1: Complete SolutionsCase Scenario 2: Data-Driven ExecutionSuggested PracticesConsider Using a Master PackageAnswersLesson 1Lesson 2Lesson 3Case Scenario 1Case Scenario 2