i am beginer in SSIS. i am trying to understand about validation usage ,its types,delay validation and validateexternal metadata. i searched it online but i didnt get any useful information. Can anyone share with me the links which talk abt validation and its types? thanks lakshmi nair

See if a package will execute blog post: http://consultingblogs.emc.com/jamiethomson/archive/2008/08/19/ssis-validating-your-package-to-see-if-it-will-execute.aspx On Delay Validation: http://blogs.lessthandot.com/index.php/DataMgmt/DBAdmin/delays-can-be-good About validation of external metadata: http://siddhumehta.blogspot.com/2009/05/validateexternalmetadata-property.htmlArthur My Blog

Hi, "Validation" is the test that SSIS does when opens a package in designer, against the data sources. SSIS try connect to each data source to refresh configured metadata. Then when you change the property Delay Validation to true, indicate that this check happen only when run package, not when open it. This property is for the whole package. Instead ValidateExternalMetadata is a similar option for each data flow task Check this link http://siddhumehta.blogspot.com/2009/05/validateexternalmetadata-property.html Vctor M. Snchez Garca (ES) (BI) Hope this help. Please vote if you find this posting was helpful. if this is an answer to your question, please mark it. http://bifase.blogspot.com | http://twitter.com/atharky

SSIS always will check the validation at compile time, when you open the package as Victor said, or when you want to run the package first of all validation will starts. sometimes when you use expressions and variables and made your package dynamic and value of variables fetch runtime you get errors in validation step, you can use DelayValidation to true to get rid of validation step. same meaning is true for data flow components with ValidateExternalMetadata .http://www.rad.pasfu.com My Submitted sessions at sqlbits.com

thanks all for your help