SqlShare.com Logo
 
Skip Navigation Links
Home
Video List
Events
Classes
About Us
Login / Register
Subscribe RSS Feed 

Confio Ignite

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.

Duration:
8 mins 36 secs
Skill Level:
200
Rating:
4.42 out of 5
Publish Date:
September 19, 2006
Using the For Each ADO Enumerator You must be logged in to view this video.  
Bookmark and Share
 
1=Poor, 3=Good, 5=Excellent

About the Author

Image of Brian Knight
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.

References



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

chetanns on 10/23/2010
excellent vid, helped me a lot.

Karl R on 3/24/2011
Awesome video - clear, consise & VERY useful! Nice.

Mick on 3/24/2011
Excellent explanation, would enjoy to hear real life examples of when to use this method

Doug on 3/24/2011
does not play: error: stream not found using the for each ADO enumerator

D000BE484E on 3/24/2011
thanks ...love the concept...10 minute breaks a day and learn 1 thing...great stuff

Sameer on 3/24/2011
Nice tutorial and presentation. Thanks

Yadava Shettigar on 3/24/2011
Very Good Keep it up..................

Neha on 3/24/2011
it was too fast for a newbie

Neha on 3/24/2011
it was too fast for a newbie

Neha on 3/24/2011
it was too fast for a newbie

Tahir A. Syed on 3/25/2011
Great but pretty fast demo...Thanks

Stevan Cohen on 3/25/2011
Too fast with little explanation about what is occuring at each step

Sneha on 3/28/2011
It is very good

Ann on 3/28/2011
awesome!!!!

Maurice Ivory on 3/28/2011
This is a very goood video that will keep my carrer prgressing.

Michael Neymit on 3/28/2011
Wonderful overview! Thank you!

Tarun on 4/11/2011
very good

Don Tulecki on 4/11/2011
Little quick but very good.

ravi on 4/11/2011
great

Hans Thunström on 4/12/2011
I have learned and used this technique earlier. But I only knew how to get data from a one-column list. Now I have learned how to get data from several columns by indexing variables. Thank you!

david on 5/9/2011
did not think of doint that . . . thanks!

nilesh_jaybhay on 6/15/2011
very good

Maurice Ivory on 8/23/2011
This presentation was great!!

Greg Joiner on 10/14/2011
You can't set the text name in the index field, only numerics are allowed.

dip on 4/8/2012
Nice, Thanks. Dip



Must Be Logged In
 

How Do I Become a Video Author? |  Newsletter History

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