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.. Thanks Danny
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 http://www.sqlbrad.com
Enable the DTS package logging to see more information on the failure and steps. Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com 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.. Thanks Danny By default it will not rollback unless you configure to rollback in DTS properties window.. MohammedU. Moderator SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
