Hello,
I need to accomplish something like: 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
Date
Votes
1 comment
-
Support Take a look at this video:
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.
Please sign in to leave a comment.