SQL Server Performance Forum – Threads Archive
DTS FAILINGHi there.. if my dts package is failing on step 5…doies tht mean tht all the steps upto 4 will be rolled back or they will be executed successfully.. Thanks
It depends. It depends on what the package is doing, and how you have set up the package to do should any step fail. Check the dependencies of the package to see how they are set up to react to step failures. Also, check the job history to see if you can see what parts the job appeared to have run. ——————————–
Brad M. McGehee, SQL Server MVP
Enable the DTS package logging to see more information on the failure and steps. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
quote:Originally posted by danny123 Hi there.. if my dts package is failing on step 5…doies tht mean tht all the steps upto 4 will be rolled back or they will be executed successfully.. ThanksBy default it will not rollback unless you configure to rollback in DTS properties window.. MohammedU.
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.