Post reply

SQL Reporting Failure when DTS executes successfully

  • July 26, 2007 at 8:21 am

    #117964

    I have a DTS package that is scheduled through SQL Agent.  The DTS package runs to completion, and shows no failed steps in the history log.  SQL Agent always reports this job as failed.  The job only has one step, which is to execute the DTS package. 

    Anyone have any idea why the job would fail when the DTS package completes successfully? 

  • July 26, 2007 at 8:33 am

    #722592

    More info:  I do have some conditional branching in  my DTS package that causes some steps to be skipped, but I use global variables to handle the branching, so there is never a failed step, but some do show up in the log like this:

    DTSRun OnProgress:  DTSStep_DTSExecuteSQLTask_25; Step was not run; status was set to Inactive.; PercentComplete = 0; ProgressCount = 0

    Would this cause the SQL Agent job to report a failure?

     

  • July 27, 2007 at 8:49 am

    #722903

    How many steps/tasks in your package? Did all the steps run? Do you have logging enabled? If not, can you enable logging, rerun the package and review the logs. Is the last step an Activex task? If so, was the "Main = DTSTaskExecResult_Success" specified?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply