ssis package execution
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
November 14th, 2011 6:07am

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
Free Windows Admin Tool Kit Click here and download it now
November 14th, 2011 6:12am

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
November 14th, 2011 6:50am

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
Free Windows Admin Tool Kit Click here and download it now
November 15th, 2011 10:11pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics