INTEGRATION SERVICES VIDEOS
- Getting started with SSIS
- Performing basic tasks
- Basic transformations in SSIS
- Using variables in SSIS
- Data types and data conversions
- Integration Services expressions
- Conditional split and derived column transforms
- Debugging in SSIS
- Lookup transforms in SSIS
- Creating FOR loops and using sequence containers
- Using FOREACH containers to loop over files
- Looping over ADO recordsets and more
- Writing scrpt tasks for control flow using C#
- Writing scrpt tasks for control flow using Visual Basic
- Creating script components within data flow tasks
- Precedence constraints and expression constraints
- Event-handling and logging
- Setting parameters and deploying projects
VIDEOS BY AUTHOR
VIDEOS BY YEAR
Integration Services videos | Looping over ADO recordsets and more
Posted by Andy Brown on 14 January 2014
Learn how to loop over the records in a SQL Server table, the nodes in an XML file, the rows in a SQL Server schema and more!
You can play this video on Looping over ADO recordsets and more here (see viewing hints below also).
You can increase the size of the video:
You can view the video in full screen mode as shown on the left, using the icon at the bottom right of the frame.
You can also increase the quality of the video:
You can improve the resolution of the video using another icon at the bottom right of the frame. This will slow down the connection speed, but increase the display and sound quality. This icon only becomes visible when you start playing the video.
Finally, if nothing happens when you play the video, check that you're not using IE in compatibility view.