SqlShare.com Logo
 
Skip Navigation Links
Login / Register
Subscribe RSS Feed 

Download a free trial of SQL Backup now

Image of Brian Knight
Author:

Author Bio:
Owner of Pragmatic Works :: Brian Knight, SQL Server MVP, MCSE, MCDBA, is the co-founder of Jumpstart TV and SQLServerCentral.com. Brian has written and co-written 9 technical books. Brian has spoken at conferences like PASS, TechEd and Connections. Brian develops solutions with Pragmatic Works to migrate DTS packages to SSIS.
Using the For Each ADO Enumerator

Using the For Each ADO Enumerator

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 dynamically.

Video Information
Publish Date:
September 19, 2006
Length:
8:36
Skill Level:
200
Rating:
4.51 out of 5

Watch Video Now!  Watch it later!  

Bookmark and Share

  Rate This Video:  
 
1=Poor, 3=Good, 5=Excellent
Comments:
Eric on 9/23/2008
Very informative.

John Dorn on 10/28/2008
Video was incredibly choppy and for this reason difficult to follow. That said, the information was very helpful.

Ken on 10/29/2008
Video not found

Mark Arnold on 12/15/2008
short sweet and just what I needed to know. Thanks

Julie Moseley on 1/13/2009
Just what I needed for my project!

Richard Cook on 2/11/2009
This video did not solve my problem; however, it covered what I was trying to do leading me to discover the real error in my solution. Thanks. RC

untitled on 2/16/2009
if I can't download it, your bandwidth bill increase. Brand the video, and let us keep a copy.

Andy Warren on 2/17/2009
Untitled - we may do that later ths year, small steps for us:-)

6575B9BAB9 on 2/27/2009
Good example, it helped with my problem and was really easy to understand

John on 4/7/2009
Very interesting information presented in this video. I will be SURE use it very soon. Many Thanks.

Murali on 5/21/2009
Nice... Thanks for the presentation

Erik Klein on 5/26/2009
A little rough, but great info.

Neeraj Verma on 7/23/2009
Not working properly :(

david tooley on 7/23/2009
Perfect I've been strugling with this for 2 days!!! Thanks for the clip!!!

Connel Bell on 9/10/2009
Very useful. Thanks.

sirandas on 9/18/2009
Great video explaining the Foreach loop container and also creating variables

mario witdoek on 9/23/2009
tx for all the effort. I'm applying for a job as BI consultant and these videos help me a lot. A LOT! maybe some videos on logging? mario

Tom Tait on 11/17/2009
Great topic: Diff subject: It'd be nice to see a video variable reference in C# code in a script task.

Ricardo Sanoja on 12/30/2009
Pretty good information

sunjer on 12/30/2009
gr8 share. thanks a million

Timothy Watkins on 1/4/2010
A very useful introduction to a dynamic SSIS

Matthew Rood on 1/14/2010
Thank you

Feroz Durani on 1/19/2010
Hi, I was really having a hard time in understanding Variables, Expressions and Loop Containers. This example was really helpfull. This will be good start for me for sure. Thank you very much. God Bless you. Regards, Mohammad Feroz

Andy on 3/15/2010
Very helpful,vastly better than books-on-line. Thanks.

Daniel Thompson on 3/22/2010
Really useful, helped me on a similar project (looping round csv files in multiple folders with import into table). Thanks.

Craig on 4/12/2010
It would be really nice to be able to save the video locally and then view it. The network at work does not allow streaming video. It is terribly inconvenient to watch at home and then try to remember everything at work. :( I hear it's a great clip though.

Joaquin Ortega on 4/29/2010
Excelent material congratulations, I was stuck in all this new to me SSIS universe.

sankar101010 on 6/16/2010
very nice thanks

Ranch on 6/25/2010
Nice Article very clear



Must Be Logged In

References
4 Day SSIS class taught by Brian.

Sponsored Ads
 

How Do I Become a Video Author? |  Newsletter History

Copyright © Fourdeuce, Inc., 2005-2009. All Rights Reserved | Privacy Policy | Terms & Conditions