New SQL Server Integration Services Video Tutorial: Pt. 2 - Using a Script Component in a Data Flow Task Transformation

Pt. 2 - Using a Script Component in a Data Flow Task Transformation - view details

Picking up from the last video, this video shows you how to add the Script Component to your Data Flow Task. You'll learn how to:

• Add the Script Component
  
• Common errors/pitfalls to avoid with Data Flow and the Script Component
  
• Input columns and Output columns in the Script Component
  
• Understanding the screens of the Script Component: Input and Output, Script
  
• A Visual Studio bug is found :)
  
• Mapping data types (DT_STR)
  
• How the script works: ProcessInputRow and Input0ProcessInputRow + Input0Buffer
  
• How to assign the value of your Output columns via Visual Basic .NET

and much more

---

• Source: http://www.LearnIntegrationServices.com
• Category: Data Transformation and Data Flow Tasks in SSIS: Moving Data From Point A to Point Z
• Skill Level: 400 (Intermediate - Advanced)
• Length: 12:30 (11.0MB)
• Applies to Versions: SQL Server 2005
• Full Details

---

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: Transform data Task