I have a directory with a number of xls files in. I would like to iterate through each and then delete once processed OR if the import fails move the file to a sub folder named 'Failed'. How can I go about doing this?
Date
Votes
1 comment
-
Mike O'Quinn Yes. Use the File System Entries source in a workflow. This will iterate through the entire directory. You then map the source file name to the data source in the data flow (use Run Dataflow workflow task). I would wrap the entire processing of the file into its own workflow following the iterator.
Please sign in to leave a comment.