hi in my ssis project i am having 5 package...by using execute package task i want to excute this all 5 package... in my first run 4 packages run successfully..1 package get error..so now i want to execute that 1 error package only how to do this in ssis

Integration Services can restart failed packages from the point of failure, instead of rerunning the whole package. If a package is configured to use checkpoints, information about package execution is written to a checkpoint file. When the failed package is rerun, the checkpoint file is used to restart the package from the point of failure. If the package runs successfully, the checkpoint file is deleted, and then re-created the next time the package is run. pls check this http://msdn.microsoft.com/en-us/library/ms140226.aspxhttp://uk.linkedin.com/in/ramjaddu

But in case of check points the package has to be reexecuted and if all the childs have executed success fully the package will execute all the childs again in case of re execution. i would suggest that you implement error handling and then handle the error and notify the administrator accordingly-------------------------------------------------------- Surender Singh Bhadauria My Blog

Hi sql.anandan, Please refer to the following links about how to troubleshoot the error: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/f679f002-841a-40c5-b9f5-5b6cf11fb64e http://msdn.microsoft.com/en-us/library/aa337088.aspx Please feel free to ask if you have any question. Thanks, Eileen