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

Confio Ignite

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.

Duration:
9 mins 10 secs
Skill Level:
200
Rating:
4.53 out of 5
Publish Date:
August 29, 2006
Looping Through and Loading Files with SSIS 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
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.

Santosh on 3/21/2010
Hi, unfortunately it's not working in my SSIS 2008 VPC. I am getting following error - [Excel Source [1]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. Also, I noticed that before editing the expression for ConnectionString it was - "

Santosh on 3/21/2010
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Geography\Asia\China\1.xlsx;Extended Properties="Excel 12.0;HDR=YES";

elsa m Platania on 3/26/2010
THANK YOU!

Arun on 3/30/2010
Thanks

sekhar on 4/5/2010
Its very useful and a wonderful presentation!!! Thanks Knight!!!

Calvin Johnson on 4/6/2010
Very Good

Mafruha on 4/7/2010
I would like to see this functionalities in Script task as well. Great demo

Rajasekar on 4/8/2010
It'svery Nice

Rajasekar on 4/8/2010
can u please tell me what is Lookup Transforamtion Editor ?

Jyotsna on 4/8/2010
Just what I needed. Thx!

Cosmin Tornea on 4/9/2010
super

dfgdddf on 4/15/2010
very professional

Al on 4/16/2010
Good training video, thank you kindly. Would you consider doing one using Excel files? Shalom

viquar on 4/20/2010
Brian, great information, and good presentation

Tarun on 4/21/2010
Excellent.....

RICK on 4/21/2010
Thank you. I wish you would have mentioned something about the Folder in the Enumerator Configuration. Thank you.

areefavallur on 4/25/2010
Thank you.

FB1769C125 on 4/27/2010
Very good and useful.

Pankaj on 5/4/2010
Very nice

Kent on 5/19/2010
Great Video. I was not sure why you deleted the user variable from the expressions propery and left the hard coded connection string? I assume that you just wanted demostrate that connection strings can be dynamci?

It is much helpfull. Thank you

Rudy on 5/25/2010
great video

James Lawrence on 5/26/2010
No video...just audio. Have been able to view others so far.

Rinaldo on 5/28/2010
Good one

Javid Khan on 6/1/2010
Excellent Demo!!! but demo speed need to be slower to understand for Non Americans.

Lokesh on 6/3/2010
gr8 presentation

mike on 6/7/2010
Thank you for a great demo

Robert Cloninger on 6/12/2010
Brian said the code source was available through a link to the left of the video but I did not see the link to which he referred.

sankar101010 on 6/13/2010
thanks

Vamsi on 6/13/2010
Nice Video over the files enumeration

durgesh on 7/1/2010
Its good but the data flow task were not explained fully

Olu on 7/5/2010
great!

Manjunatha on 7/7/2010
good

Kip Birgen on 7/21/2010
The sample of the files dat files are there but i can locate the sample Package for practise.

BIN XU on 8/3/2010
This is very excellent video. But if you could explain the Data flow task inside this project, you will make this video lesson more complete. Great job.

Anil Inampudi on 8/20/2010
gud one

Anil Inampudi on 8/20/2010
gud one

Nasir on 10/7/2010
waaw! makes life seem easy & simple! This is how SSIS has to be explained! Thanks for the Demo..

anil on 2/8/2011
..nice one brian just love to learn more about ssis .. :)

Sudhir on 2/8/2011
Easy & clearly explained. Lovely

hugo on 2/8/2011
very nice, well explained

Irfan Mohammed on 2/8/2011
Are you going to catch a Flight after generating this video clip. I was little surprised....... you are too fast.

Michael McAllister on 3/12/2011
This guy is so good and explains thins well

Vandecan on 3/23/2011
super!

Louie Velez on 3/23/2011
Just finish this same methods and if I had watched this video first I might have saved 8 hours of lesson learned.

DP on 3/26/2011
For Each Loop Basics are demoed excellently.

Rani on 4/12/2011
Excellent teaching

Karl R on 4/13/2011
As usual, an excellent video. Thanks!

Russell Tye on 4/19/2011
Excellent job.

Sal on 4/19/2011
This video would be excellent if it had a printable tutorial to go along with it. The videos are great learning tools but you need a hard copy for reference to actually do the exercise. They would also be a great reference at a later date to refresh your memory.

Jay Maley on 5/23/2011
GOOD STUFF!!

Brynn Binnell on 5/31/2011
Excellent. I'm trying to bulk load xml files into a table, then run a script that shreds the xml column (I know I can do this in SSIS, but in this case I need to use existing scripts). I can't get it to bulk load the file to start with because somehow I'm not making the connection between the file name variables i'm looping through, and the Execute SQL Task that contains the bulk load command. Any ideas ?

Jason Vollaire on 6/20/2011
Love it!

sukesh on 7/10/2011
nice

Mike Candlewood on 8/15/2011
This was great and very clear. Thank you!

Michael Dudash on 6/20/2012
bknight is a great presenter!

jeff ewing on 7/31/2012
Little choppy



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