Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SQL Server DBA Videos · SQL Programming Video Training
     
SQL Server Integration Services Training Videos             * SQL Server DBA Videos
* SQL Programming Video Training
* More Videobooks...
Email
Password
Register
LearnIntegrationServices.com Subscriber Videos
Integration Services Video Tutorial Home  Subscriber Videos  
Working With the Foreach Loop Container - Iterating Through Files in a Folder - Training Video
   Category: Creating SSIS Packages - Container-based Tasks
Download! Skill Level: 300 (Intermediate)
Duration: 16:02
Size: 16.00MB
Versions/Editions Covered: SQL Server 2005
Added/Updated: Dec 18, 2006
Staff Pick!
Download this video
Often we need to load data that is in text files (also called flat files) and insert their rows into a table. This video talks about using the Foreach Loop Container and the Foreach File Enumerator along with user variables to loop through each file in a given folder.

This video helps you create an SSIS package that takes every file in a folder and loads the data into a SQL Server table.

Highlights from this video:
  • Traversing subfolders using the Foreach Loop Container
  • Avoiding the use of ActiveX Script or the Script Task in favor of using the native SSIS tasks for iteration (no more scripting!)
  • Using the Script Task to report the filename (fully qualified and/or the file name only)
  • Creating variables and assigning variables in the Foreach Loop Container
  • How to use masks to determine which files in a given directory to load
    • Only load .txt files
    • Only load files that begin with Employees_ and end in .dat (i.e., Employees_2006.dat or Employees_NewYork.data but not Customers_2006.dat)
  • Using Connection Managers with Expressions to assign connection strings based on the Foreach Loop Container's variable assignment
and much more
Tags for this video: FileSystemObject FSO iterating looping loops MoveNext objFSO recursion recursively vbscript  
< Back Download this video
AddThis Social Bookmark Button
People Who Downloaded this Video Also Downloaded:
TitleSkillDownload
Pt. 2 - An Overview of Using SSIS - Using SQL Server Management Studio 100 Download
Pt. 1 - Expressions - An Introduction to Using Expressions in SSIS 300 Download
Pt. 3a - An Overview of Using SSIS for Newbies and Beginners - Using BIDS 100 Download
Pt. 1 - An Overview of Using SSIS for Newbies and Beginners 100 Download
Pt. 3c - An Overview of Using SSIS for Newbies and Beginners - Using BIDS 100 Download

About the Instructor:
Scott Whigham Scott Whigham is the founder of LearnItFirst.com, one of the web's most extensive video training libraries focusing on technical training. Scott is also an experienced consultant, trainer, and author with more than a decade of hands-on experience working with SQL Server databases, writing and debugging applications using Visual Studio, and performance tuning. Scott designed the architecture (websites, class libraries, and database) for the LearnItFirst.com websites and, most re... (Scott Whigham's full bio can be found on the About the Author page)
Video search
Company News
Windows 2003 sysadmin training videos
     
Home | About Us | Advertising | Become an Author | Contact Us | Privacy | System Req's | Terms | Testimonials | Work for Us! | Blogs | Site Map Refer a Friend and Get a Free Subscription!
© Copyright 2004-2008 LearnItFirst.com LLC. All rights reserved. All trademarks remain the property of their respective owners.
This site is not affiliated in any way with the Microsoft Corporation.
8/7/2008 2:49:10 PM