after running DTS on ASP, query doesn't work anymore?!

[rwei]

Hi, all,

Please confirm if this is true.

I clear the destination table outside the DTS before I run a simple DTS package from an ASP page, then I check the destination table's row count to see if the DTS has completed successfully.

However, this execution of the simple SQL stored procedure query in the ASP against the destination table doesn't seem to be working anymore after the DTS execution?!

I do something similar on the destination table before the DTS execution, and it seems to run fine.

Does this happen to you?

After the execution, I do something like:

objPkg.Uninitialize
Set objPkg = Nothing

to clear everyhing.

Please help.

 

[rwei]

With more testing on this problem...

It does seem to me that the table involved in the DTS execution is still being 'locked' after the DTS completes. I can't do any SQL operation on it, not even SELECT.

What else I need to do other than "UnInitialize" in my ASP code?