A while ago I write a quick post on how to loop through an ado recordset in ADO. It seems to be a common question on the newsgroups so I decided to produce a how to video on how to loop through an ADO recordset in SSIS.
Author: Knight, Brian
Description: In this video, you'll learn how to use the For Each ADO enumerator to loop through a table and reconfigure the package based on the rows in the table. You can use this type of example to store meta data about your client and reconfigure the package for each client
Brian
I've created a few new videos last night for JumpstartTV.com. One video gives you an overview of this cool database high availability feature in SQL Server 2005 and then the next video shows you how you can integrate snapshots into SSIS. Registration is required on the site but it's free.
Description: In this presentation, Brian shows you how you can use database snapshots for data protection. He shows you how to create a snapshot, read from it and lastly how to do a database recovery from the snapshot.
Description: Database snapshots provide a handy way to provide data integrity for Integration Services. In this presentation, Brian shows you how to create a package that can "self-heal". In the event of any problem, the database will automatically roll back to a pre-ETL snapshot.
-- Brian