Tagged with ssis - Visokio Forums http://forums.visokio.com/discussions/tagged/ssis/feed.rss Mon, 30 Oct 17 20:27:28 -0400 Tagged with ssis - Visokio Forums en-CA Idea: DataManager - 'For each file' loop/batch process? http://forums.visokio.com/discussion/601/idea-datamanager-for-each-file-loopbatch-processs Wed, 19 Jan 2011 11:30:27 -0500 edtclarke 601@/discussions
I needed to perform a number of tasks on each file, before appending them together so batch append wouldn't have been appropriate. What would have worked well is a batch container which would perform a given set of operations to every file passed. You can do this in SSIS (for each file loop container) - it saves time and keeps the process map a lot cleaner and easier to understand.]]>