SSIS 2008 Training Video: Using Variables in the Foreach Containe r: Looping Through Every Row in a Table/Result Set, Part 2

Using Variables in the Foreach Container: Looping Through Every Row in a Table/Result Set, Part 2 - view details
This second video covering using variables in the foreach container to loop through every row in a result set. This video will show what each index in the foreach container maps to in the SQL Server result set. Scott will also show you how to troubleshoot in the foreach container. How do you change variables from read-only to read-write? It's not intuitive and requires a deeper understanding of DTS packages.

Highlights from this video:Practical applications of the foreach container
Troubleshooting in the foreach container.
When should you use read-only variables?
Creating a read-only variableChanging a read-only variable to a read-write variable
and much more Source: http://www.learnitfirst.com/Course/158/Video/2125/Pt2-Looping-Through-Every-Row-In-A-Table-Set.aspx Course: http://www.learnitfirst.com/Course/158/SSIS-2008.aspx Skill Level: 300 (Intermediate) Length: 13:30 (25.5MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: SSIS 2008, variables, foreach container, looping, mapping, troubleshooting, read only variable, read write variable

This video comes from the SSIS 2008 online training course, SQL Server 2008 Integration Services. And be sure to check out even more SQL 2008 Integration Services training videos.