DTS FAILING | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

DTS FAILING

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.
]]>