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

Confio Ignite

SSIS For Loop Container

If you know the number of times a task is to be performed you can use a for loop container which is very similar to the for loop in programming languages.

Duration:
2 mins 60 secs
Skill Level:
100
Rating:
3.92 out of 5
Publish Date:
April 06, 2010
SSIS For Loop Container You must be logged in to view this video.  
Bookmark and Share
 
1=Poor, 3=Good, 5=Excellent

About the Author

Image of Rochak Tarika
I am working as a system engineer in an IT company in India. My work profile includes working as a trainer in Business Intelligence space and my expertise lies in Microsoft Business Intelligence Development Studio specially in SSIS.

References

There are no downloads or recommended reading links for this video

Comments
Vincent DANIEL on 4/6/2010
Very good presentation !

gork on 4/6/2010
Yeah, the loop container works, but it is totally impractical for a large number of iterations because it is soooooo slow.

Mike Salo on 4/6/2010
Good info

Team FAB on 4/6/2010
the language is pronounced "c-sharp" not "c-hash"

alfred kennedy sr on 4/6/2010
My 1st time. Very informative, helpful.

Ron Newlin on 4/6/2010
A little hard to understand the presenter. But OK

ramanathan on 4/6/2010
good one

yogesh on 4/6/2010
nice one

borjonx on 4/6/2010
good speaker for such a thick accent.

Raveendran on 4/6/2010
The Video Tutorial is Good and easily understandable.

Rochak Tarika on 4/6/2010
@Team FAB thanks for pointing that out...my mistake... Others...Thanks for your encouraging comments

Vincent Pernice on 4/6/2010
Nice but poor sound quality.

Gnana Sambantham on 4/6/2010
Simple and nice..

Erik Sukraw on 4/6/2010
Thanks,,, very informative.

Darrell Prather on 4/6/2010
Very nice.

Adam Sottosanti on 4/6/2010
Appreciate the quick tutorial, thank you!

Chris on 4/7/2010
a bit too simple.

Anthony on 4/7/2010
Very useful for getting started.

manish on 4/7/2010
very good tutorial for SSIS beginners!!keep it up dude. manish_Wamanker@Hotmail.com

Vivek on 4/7/2010
go rochak go rochak go.... go rochak go rochak go.... go rochak go rochak go....

Steve Harris on 4/7/2010
maybe explain how you could change the maximum number of iterations

jahnavi on 4/7/2010
Hi Can u tell how to use dts task inside for loop cointainer

Rochak Tarika on 4/7/2010
@Steve - Here we are iterating depending on a variabe so if you think thata iteration will depend on some other constraint you can change the value of teh variable by using a script task or any other way and the for loop will run until the Counter reaches the max limit defined.

Rochak Tarika on 4/7/2010
@jahnavi - yes you can use it.But there are very less cases where you use a dts task in for loop.Because in case of dts task we are talking about iterating files which we can easily do by ForEach loop container.

MattP on 4/8/2010
Sound quality not very good

chapas on 4/8/2010
Basics...

Raveendran on 4/8/2010
gud

Bom

Vinay on 4/21/2010
Its good, If u would have give an example with data flow task then it would be EXCELLENT

Joaquin Ortega on 4/30/2010
Quite illustrtive

Stevan Cohen on 5/4/2010
A little more depth would be nice

mrjohnfreeman on 5/5/2010
Difficult to understand because of the strong accent. Otherwise, I'm sure it was good.

sam on 5/8/2010
Hai This is sridhar .Your video simple and nice. thanks

Rochak Tarika on 5/9/2010
Thanks all for the encouraging comments. I'll surely take care of the sound quality and try to improve on making my accent more clear in my future videos.

Kurt on 5/17/2010
You might want to get a better mike. It sounds kind of scratchy but otherwise a good video.

Venkata on 5/18/2010
Very Nice.....

Max Turavani on 5/26/2010
ForLoop container for dummies

Narayana on 6/7/2010
very good one

krishna on 6/14/2010
cfhxdfyxfufxu

satya on 6/14/2010
great

Steve Ramp on 6/15/2010
Very Nice, clear and concise

Nilam on 6/16/2010
v.good

Anuja on 6/20/2010
hi can i have your email address, I work as ETL developer in Insurance company in NYC. I need your help as I stuck into one problem. Thanks for posting this vedio.

Rochak Tarika on 6/21/2010
@anuja you can mail me at rocky_tar@yahoo.co.in

skaykov on 6/24/2010
useful example

BIN XU on 7/20/2010
Good Presentation!

Dima on 7/22/2010
Very good video. Thank you !

sujay on 8/27/2010
nice

Harold on 12/22/2010
Great info for a short video.

Amit on 5/10/2011
Please provide practical example where we must use the FOR LOOP container

Sameer on 5/12/2011
Good for understanding basic concept of For Loop container. Thanks

shailendra on 6/27/2011
wow rochak :)

vinay on 7/25/2011
Nice Video.. Thanks..

Saikumar on 12/30/2011
Simple and very good

Alok on 1/11/2012
good

srinukornu on 3/13/2012
nice article

Tom Hamilton on 5/3/2012
Thank you



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