SqlShare.com Logo
 
Skip Navigation Links
Home
Channels
Classes
About Us
Login / Register
Subscribe to the All channels feed  Goto the SqlShare.com blog
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.
Looping Through and Loading Files with SSIS

Looping Through and Loading Files with SSIS

In this presentation, you'll learn how to use the ForEach Loop Container to loop through a folder and load each file in the directory. This presentation uses variables to dynamically configure the package so nothing is hard coded.

Video Information
Publish Date:
August 29, 2006
Length:
9:10
Skill Level:
200
Rating:
4.51 out of 5

You must be logged in to view this video.    

Bookmark and Share

  Rate This Video:  
 
1=Poor, 3=Good, 5=Excellent
Comments:
Ricardo on 9/10/2008
audio. No video. Flash player 9. Windows XP

Mark on 9/24/2008
Please more videos about Data Flow tasks

Dale Moore on 9/26/2008
Good Video

JumpstartTV on 9/29/2008
Video not very smooth some steps are missing. If you can Start From Scratch that will be fintastic.

Rich on 10/1/2008
Exactly what I was looking for. Great video!

Jon Sommervold on 10/6/2008
Very informative!

Peter on 10/29/2008
It didnt exist!!!

Chris Rock on 10/30/2008
Peter, you may be behind a firewall that is blocking RTMP stream. It's a very common problem when working in a corporate environment. If not, please send an email to webmaster@jumpstarttv.com for more support.

Roy C Rice on 11/19/2008
This addresses an issue we have been dealing with

Chathura on 11/20/2008
this is very helpful

Mike Fieldman on 11/26/2008
How can I please download the project with source code? All I get is the raw data. Thank you.

vijay on 11/29/2008
Excellent

sree on 12/3/2008
really helpful. looking for applying this for receiving multiple ftp files

Alasdair on 12/24/2008
Clear concise and just what I needed!

mehmet on 12/30/2008
Thanks so much for sharing your knowledge.

Suresh on 1/15/2009
Great

Ash on 1/26/2009
great stuff

R on 2/2/2009
Thanks

R on 2/2/2009
Thanks

R on 2/2/2009
Thanks

tony on 2/9/2009
Very well presented and useful...thank you

Venkata Taduri on 2/9/2009
I need to watch couple of times.. nice video.

Kim Riggs on 2/10/2009
Thank you so much for making these videos. They have been extremely helpful.

Raalnan Five on 2/13/2009
For some reason, it does not work for me. probably my fault.

Feroz Durani on 2/21/2009
very helpfull video indeed

Tim on 3/6/2009
stutter?

Travis on 3/31/2009
Very helpful, but the speaker needs to slow down and spit the chewing gum out first....

Chris on 4/1/2009
Could not view video. It said 'Stream Not Found'

XXX on 4/7/2009
excellent

XXX on 4/7/2009
excellent

guru prasad on 4/8/2009
Awesome video!!

Allison on 4/21/2009
Very clear - great examples. Thank you so much!

dibyant upadhyay on 4/22/2009
great!!!

Mike Street on 4/29/2009
Didn't get the single user variable choice in variables mapping. Was that created or a default variant type variable ? Then why was it deleted?

Brian Knight on 4/30/2009
Hi Mike, it was created. You can also select New Variable to create a brand new string variable.

Jeremy Pryor on 4/30/2009
I feel like I just to a speed course in SSIS packages, but there are no ill effects from it. Thanks for the accurate easy to follow instructions, nice work.

Inland IT on 5/1/2009
great presentation

Dipak Saha on 5/1/2009
Nice video.

Darrell Prather on 5/28/2009
Nice presentation.

John Chappell on 6/1/2009
This was good.

mari on 6/4/2009
Really its very helpfull for me this video

Abdourahmane on 6/10/2009
great!

Cindy Gaudette on 7/1/2009
Perfect! Exactly what I need to do. Now I'm trying to add a datestamp to the archived file.

James Moore on 7/22/2009
Excellent!!

John on 7/29/2009
Great video, thanks!

Shanon Bailey on 8/6/2009
Would love to see an example of files that have date/timestamp added in the file name and iterate through those.

Hannah Li on 8/7/2009
cannot download the sample packages. Only the .dat files

Chun Chang on 8/12/2009
Perfect! Thanks!

Chris Sindoni on 8/13/2009
Presented well. I have done this in the past and needed a refresher on it. I wish I had seen this when I first approached this. It would have saved me at least a few hours.

srinivas on 8/16/2009
Nice tutorials

Praveen on 8/31/2009
Thanks! this video will help a lot

Steve on 9/1/2009
Excellent demo!

Arun Lazar on 9/3/2009
reallly good one

rupesh sharma on 9/11/2009
Excellent

Venkateshwaran on 9/16/2009
good

JohnG on 9/25/2009
That was a fast presentation.

Richard Ray on 10/2/2009
When I attempt to build the expression for my connection string I get an error when I try to evaluate the expression, the ol' 'Object reference not set to an instance of an object.' chestnut. Any ideas?

Richard Ray on 10/3/2009
Never mind - can't do package development on my workstation but it works on the data server. I'll have to figure that out...

Steve Culshaw on 10/10/2009
Video doesn't show the flicking as the four files are loaded

Alok on 10/15/2009
Nice

habiballah_salimi on 10/26/2009
not only poor video performance but also have a good knowledge!?! thanks

Graeme Muchan on 10/29/2009
Brilliant Brian that totally just solved what I was struggling with. The videos are an excellent resource with SSIS, I don't think I could work without them as I find SSIS resource sometimes a bit sketchy!

Ravi Kallamadi on 11/12/2009
This is an excellent presentation. Everything is very clear and I really appreciate it.

Dana Stevenson on 11/16/2009
Excellent lesson on having containers to manage loading files in a directory. Thanks for the tips about variables too!

garbski on 12/7/2009
Just when I needed when I found out some poor person has to download hundreds of files a day and combine them into one big happy db!

8A7E4A6C54 on 12/15/2009
Fantastic. Just what I needed. The guru Brain Knight does it again.

Tcharly Florestal on 12/15/2009
Very nice. Than, Bryan.

Julie Egbert on 12/22/2009
Thank you this was great help and made easy.

Eva on 12/24/2009
Excellent information

Andres on 12/24/2009
Great presentation!

Leon on 1/12/2010
Clean and remarkably to the point, amazing how close this is to what I try to achieve this week!

Saibal on 1/12/2010
Nice work.

Per on 1/14/2010
Thanks! This was excellent.

Leonard Peoples on 1/15/2010
Perfect.

BIUser on 1/18/2010
very nice ... can u plz tell me hw to create the xml variable i mean create configfiles for connection string thanks in advance...

Lutz on 1/29/2010
Great video but I can't find the files you mentioned in the beginning.

reena guntur on 2/1/2010
nice

nilanaksha on 2/8/2010
Nice One to learn SSIS

nilanaksha on 2/8/2010
Nice One to learn SSIS

Divya on 2/9/2010
Loved the lucid way of explaining things in ur vidoes...cheers

Tina on 2/12/2010
Thank you for taking the time to share your info with everyone!

faizan on 2/19/2010
Good demonstration. it help me

Jim on 2/20/2010
Mr. Knights presentationas are always spot- on!

Chandana Mukka on 2/24/2010
That quick and direct.

James Lawrence on 2/26/2010
Lots of useful info here...however, you might want to slow your rate of speech down just a little. Sounds like you're in a big hurry!

king yute on 2/28/2010
great

Andreas Beuschel on 3/3/2010
Great presentation

Steve M on 3/3/2010
I think this has given me the ability to set up a package that can loop through my SQL Servers looking for information that I need to report or respond to (like a DB starting).

Milton on 3/4/2010
awesome

Vikas Kumar Anand on 3/6/2010
EXCELLENT

carylon anteau on 3/9/2010
Great Video. I look forward to seeing more SSIS videos since I am currently trying to recode our SQL 2000 DTS packages to use SQL 2005 SSIS.



Must Be Logged In

References
Download the example tutorial chapter from Brian's book.

Download the sample code used in this presentation

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