I have set DelayValidation as TRUE at package Level(Control flow). Do I need to change the same for each and every component present in the control flow? Thanks PAritosh

The short answer is no if you do not need the package validated, but the individual components will be. It is a good practice to turn off the validation on only select components (e.g. a DFT if you expect run time errors) when you deploy a package. See this article for more information: http://www.sql-server-performance.com/articles/biz/SSIS_Features_And_Properties_Part4_p1.aspx Arthur My Blog

I have set DelayValidation as TRUE at package Level(Control flow). Do I need to change the same for each and every component present in the control flow? Thanks PAritosh That depends on why you're setting DelayValidation to TRUE in the first place. You may need to set this on connection managers, data flows, etc... to avoid up-front validation which may not be possible if you're doing dynamic assignments, for instance.Phil Brammer | http://www.ssistalk.com | Twitter: http://twitter.com/PhilBrammer