Search 
Sunday, May 20, 2012 ..:: Home ::.. Register  Login
 IR Events Minimize
<May 2012>
SunMonTueWedThuFriSat
293012345
6789101112
13141516171819
20212223242526
272829303112
3456789
 Print   
 IR Visits Minimize
Membership Membership:
Latest New User Latest: A95
New Today New Today: 0
New Yesterday New Yesterday: 0
User Count Overall: 44
People Online People Online:
Visitors Visitors: 1
Members Members: 0
Total Total: 1
Online Now Online Now:
 Print   
 IR Blogs Minimize
 Print   
 Links Minimize
 Print   
 Welcome! Minimize

Welcome to Infinite Randomess... Here you will be able to find out all information about the endevors that I am currently undergoing in my life as well as historical information.

The content of this site can be fairly detailed, as such I'm asking friends and family register with my site. This will allow me to control access to some items, I plan to make as much information as possible avaiaible on the public site, however, it definatly won't be everything.

I'm hoping to use this site in order to help facilite better communication of information from myself to my friends and family, to keep people more up to date on the ongoings on my life. As we get older, it gets harder to keep in touch with everyone. Lives go in different directions. I welcome friends and family to join this site and make is a community.

-Dan
 Print   
 SSIS: Foreach Loop over a directory of DBF files. Minimize
Location: BlogsInfinite RandomnessSoftware Development    
Posted by: infrandom 3/28/2006

This package will use the Foreach loop to iterate through a directory of DBF files. In the DataFlow the OLE DB Source component will open each of the files. The Script Component will MsgBox the variable fileName (note: it will msgbox for each row in the file).

Connection Manager Setup:

 

 

Control Flow:

Foreach Loop Config:

 

 

 

DataFlow:

 

OLE DB Source:

 

Script Component:

 

Execution Results:

 

 
Permalink |  Trackback
Comments (3)   Add Comment
Re: SSIS: Foreach Loop over a directory of DBF files.    By Baldev on 8/22/2007
Looks like what I have been looking for, I use dBase files to do all the processing at my work place. does it mean I can use the OleDB source to connect to dBase tables and perform row transformations like with SQL tables?
Re: SSIS: Foreach Loop over a directory of DBF files.    By infrandom on 12/6/2007
Yep, once you have read the data source you're free to go about any transformations.
Re: SSIS: Foreach Loop over a directory of DBF files.    By wd on 12/9/2009
The English author,<a href="http://wars.swagblack.com" title="The Wars">The Wars</a> Richard Savage, was<a href="http://wars.swagblack.com" title="web games">web games</a> once living inLondon<a href="http://wars.swagblack.com" title="free web game">free web game</a> in great poverty.<a href="http://wars.swagblack.com" title="online web game">online web game</a> In order to<a href="http://wars.swagblack.com" title="web game">web game</a> earn a little<a href="http://wars.swagblack.com" title="free web games">free web games</a> money he hadwritten <a href="http://wars.swagblack.com" title="web gaming">web gaming</a>the story of<a href="http://wars.swagblack.com" title="web online games">web online games</a> his life, but <a href="http://wars.swagblack.com" title="on web games">on web games</a>not many copies<a href="http://wars.swagblack.com" title="free online web games">free online web games</a> of the bookhad<a href="http://wars.swagblack.com" title="play web games">play web games</a> been sold in<a href="http://wars.swagblack.com" title="new games on the web">new games on the web</a> the shops, and<a href="http://wars.swagblack.com" title="play free web games">play free web games</a> Savage was living <a href="http://wars.swagblack.com" title="game web site">game web site</a>from hand tomouth. <a href="http://wars.swagblack.com" title="web game sites">web game sites</a>As a result<a href="http://wars.swagblack.com" title="on the web games">on the web games</a> of his lack<a href="http://wars.swagblack.com" title="web games online free">web games online free</a> of food he became very ill.<br>

Your name:
Title:
Comment:
Add Comment   Cancel 
  
Copyright 2006 Psychogenic Syndicate   Terms Of Use  Privacy Statement
DotNetNuke® is copyright 2002-2012 by DotNetNuke Corporation