New SQL Server Integration Services Video Tutorial: Pt. 3 - Customizing the Script Component Transformation with VB.NET

Pt. 3 - Customizing the Script Component Transformation with VB.NET - view details

This video focuses on editing your Visual Basic script (in the VSA editor) to define your transformations are. You'll use the .NET Framework's string manipulation capabilities to split a single column into two output columns.

Highlights from this video:

• Using char arrays to store valid delimiters
  
• LastIndexOf vs. LastIndexOfAny
  
• Using Row.Property and understanding how Row properties are set

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 (10.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