August 26, 2003 at 6:27 pm
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
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
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