SQL Server Performance

DTS FAILING

Discussion in 'SQL Server DTS-Related Questions' started by danny123, May 7, 2007.

  1. danny123 New Member

    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
  2. bradmcgehee New Member

    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
  3. satya Moderator

    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.
  4. MohammedU New Member

    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.

Share This Page