Consider the following scenario: I have a large number of SSIS Packages in a project. Assume that some change invalidates some of those packages. How can i find which packages are invalid without executing them? Is there some way to auto-validate all the packages before actual execution??? Any help is appreciated... ThanksIntellisense

I actually have a DOS script that do that: it encompasses merely a DTExec with the /Validate switch that just validates packages w/o actually executing them. I then dump the output as Validate_Packages.cmd > Validation_Result.txt to inspect. Arthur My Blog

This was exactly what i was looking for..... Many Thanks ArthurZ However, in case of invalid packages the log file gives all the error details... Is there a way to configure the "dtexec" to show only the validation status of the packages and not the error details. It would be even better, if the log file contained the validation status of only those packages that have failed the validation... Intellisense