Hi, I explain my problem here.. I have 3 files say File1,File2,File3... i chk for a state condition against table for file in db (which is a Stored Proc)if(file1 = 'loading') and file2=('loading') execute package 1 when this execution starts i set file 1 and 2 to state 'Processing..' then i check for the condition if(file2 = 'processing') and file3 = loading) or (file2 = loading and file3 = loading)execute -package 2. Problem is package 2 shd be smart enough to check the state of file 2 and wait until the file2 state becomes 'processed' from 'processing' and execute file3 processing only.But for some reason if the file 2 state becomes 'error' or 'ready to load' it shd execute both file 2 and file 3 together. Any help with an example wil be appreciated

Re #4: "wait" this is possible if you implement a ForLoop: Put Packge to Sleep http://consultingblogs.emc.com/jamiethomson/archive/2006/10/23/SSIS_3A00_-Put-a-package-to-sleep.aspx To check conditions you need to use Precedence Constraints with expression: http://blogs.msdn.com/b/mattm/archive/2006/10/30/using-expression-based-constraints.aspxArthur My Blog

thanks arthur,will check these and let you know..

Arthur, How can we achieve this scenario: 1.load file2 and File 3 on some condition vs load only file 3 on some condition in the same package???