SSIS move several already connected tasksfrom a for each loop container to a sequence container
Posted on 2011-09-19
I am editing an SSIS package previously developed by another programmer.A part of this package processes files in a folder using for exch loop container and I need to add a constraint to check if the file has been processed previously, it should not be processed again. For this I added an execute sql task in the for each loop container that queries the history table and sets the value of intFileProcessed to the number of record found in that table for this file name. If the value of intFileProcessed > 0 i do not want any other taskes in this for each loop container to execute, so I want to put them in a sequence container and connect this sequence container the my execute sql task that queries the history table with the the constraint and expression intFileProcessed <1.
All the existing tasks (about 50 of them) are already connected, and SSIS does not let me move connected tasks in this new sequence container. Is there any other work arround?