Post reply

DTS Fails to Follow Workflow

  • August 26, 2003 at 6:27 pm

    #106367

    I have a DTS Package which records it's progress to a table using the workflow for success and failure. It has a SQL Task that is failing due to insufficient user permissions; however, it will not execute the failure workflow and update the record in the progress table using an ActiveX task. Does anyone have some suggestions?

  • August 27, 2003 at 9:56 am

    #471634

    I had a vert similar issue. I solved by deleting the task and recreating it. That solved my problem.

    Also for my own information is your On Failure Active X Script suppose to write error messages into an Audit DB? If so I have the same code and it does not work to well.

  • August 27, 2003 at 10:05 am

    #471636

    My ActiveX Script Task uses ADO to connect to the database and update a ProcessStatus table with values from some Package GlobalVariables.

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

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