How to cycle through files in the folder

Lauren

July 21, 2014 21:52

None

Hello,

I need to cycle through excel files in the folder (assume that all files have the same format), take a couple cells from each file and paste into SQL database. How can I accomplish this?

Date Votes

1 comment

0

Mike O'Quinn July 21, 2014 22:32

Take a look at this video:

http://youtu.be/1RBHl_ekcoQ

it describes the "File System Entries" source in the toolbox. You can use this source to loop through a directory and process each file in a single dataflow.

Comment actions Permalink

Please sign in to leave a comment.