New SQL Server Integration Services Video Tutorial: Pt. 4 - Using a Script Component as a Source Connection

Pt. 4 - Using a Script Component as a Source Connection - view details

This video talks about when you would need to use a Script Component as a Data Source in a Data Flow task. Need to process unusual text files or text files with multiple delimiters with SSIS and use them as a Data Source? The Script Component is perfect!

Highlights from this video:

• Reading .INI files as relational data
  
• Understanding the Connection Manager tab in the Script Component
• Using Me.Connections to access connections
• Best Practices for using Output and Input column names
  
• Using <Output Name>Buffer.AddRow()
  
• Accessing row properties in Visual Basic .NET
  
• Writing VB.NET code to add rows to the output

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: 10:30 (9.5MB)
• 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