One crude way that comes to my mind right now is that if you combintions are less you could have 7 separate flow crated for each category. Trigger each flow based on the category file that is dropped.My Blog | Ask Me | Test your SSIS skills

Hi, I have few feeder files which hit the directory say c://Files at different times,i am doing an polling mechanism to check them and process thm to respective tables.But there are 7 packages for each category,the above files fall in to any of these categories or multiple categories.the relation between files and categories is defined in a config file.i am using a script task to read the category dependency but i am stuck ata point where file 1 is used by category 1 and also 2 but only one of the categories can process that to the summary tables.I have a manifest table where i update the files state (loading ,processing,loaded)How can i achieve it?kinda,threading process...

Hi, One option could be that you have a master package calling the 7 packages as child packages. Have theprecedence based on the file categorand the order in which you want to execute them.My Blog | Ask Me | Test your SSIS skills

thanks sudeep for the reply... but for example my child package 1 needs file 1 and file 2 to run.. child package 2 needs file 1 and file 3.then child 2 or 1 should be smart enough to know that other guy is using it so it shd wait until execution is done...and its kinda event driven...any inputs??