I am having problem in creating DTS package. I have 4 steps in DTS package.
First step is an activex script calling from asp file to copy files from one
folder to another.
Second step is an sql task to delete data in temp tables
Third step is again an activex script calling from asp file to import text
data to temp table.
Fourth step is to approve the transaction through an Stored procedure.(sql
task)

Right now i am facing problem in Third & Fourth steps. In third step it takes
nearly 1 hour to process and after successfully completing the task fourth
step should start. I even assigned work flow as on success option but DTS
package does not wait until it get message/return value from asp page and
continue fourth step.

Now the third is initiated and once the process is going on it active the
fourth step also.

Can anyone help me to overcome this issue?

--
Kishore

kishore k via SQLMonster.com wrote:
If your precedence constraints are being satisfied too early, which says
to me the third step has finished, well as far a DTS is concerned. Try
turning all logging to help correlate the timings.

I;d suggest there may be some issues with the code calling the ASP, or
the ASP itself. Perhaps the ASP page just times out if you are holding a
connection open, expecting to wait the full hour.

Perhaps add some logging in the ASP side as well. Without seeing all the
code at both ends it is a bit difficult to tell.



--
Darren Green
http://www.sqldts.com
http://www.sqlis.com