New SQL Server Integration Services Video Tutorial: Pt. 5 - Customizing the Script Component to be a Data Source

Pt. 5 - Customizing the Script Component to be a Data Source - view details

This video continues the VB.NET coding for creating our Script Component and making it a data source. You learn how to open the text file, read a line, and make a decision as to whether or not the line's data should be written to the destination.

Highlights from this video:

• How to read a text file in Visual Basic
• How Peek() works
• Using the StreamReader, File and String classes
• How to access connection manager properties (such as Me.Connections..ConnectionString)
  
• How to use a MessageBox in SSIS
• Using ReadLine() to read a line of text in your text file
  
• How to notify SSIS that you are at the end of the Source rowset with EndOfRowSet()
  

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: 500 (Advanced)
• Length: 10:00 (9.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: EndOfRowSet