SSIS 2014, Part 07 of 11: Scripting Components
You can add script to an Integration Services package in two main ways, both of which you’ll learn about in this course. First you’ll learn how to use the Script task to add script to a package’s Control Flow. Then you’ll learn how to use the Script Component to add script to a package’s Data Flow. These two components are quite different. The Script task usually executes once in the package, or perhaps once per loop in a looping container. The Script Component executes once per row in the Data Flow, and may end up executing millions of times each time the package executes if there is that much data to process. This is why there are separate components for the Control and Data Flows: the requirements of each are quite different. As a result, the code you’ll write for each is quite different, as you’ll learn in this course.
Lesson 1:
- Integration Services Scripting
- Custom Component Development
- Integration Services Scripting 2
- When to Use IS Scripting?
- When NOT to Use IS Scripting?
- IS Object Model.
Lesson 2:
- Demo: A Simple IS Project
- Demo: Configuring Script Task
- Demo: Executing a Script Task.
Lesson 3:
- Scripting in Control Flows
- Variables
- Variable Collection
- Accessing Variables
- Ordinals Positions
- VariableDispenser Object
- VariableDispenser Example.
Lesson 4:
- Demo: Creating Variables
- Demo: Development Environment
- Demo: Add More Script Tasks
- Going Beyond Built-In Tasks.
Lesson 5:
- The Script Component
- Input & Output Columns
- Script Component Types
- Script Component - Source
- Script Component - Destination
- Script Comp - Transformation
- Synchronous vs Asynchronous
- Transformation Synchronicity
- Script Component Synchronicity
- Asynchronous Transform Types
- Building Async Transformations.
Lesson 6:
- Demo: Create Script Component
- Demo: Configure the Component
- Demo: The VSTA Environment
- Demo: Execute Flow Task
- Going Beyond Built-In Data Flow.
