I've been having problem running DTS from ASP. And finally, I created a VB
DLL and call it with client-side VBScript from ASP. And that finally works -
I think by doing this, I've bypassed the IIS permission issues.

However, right after the DTS execution, any of the SQL query (Select or
Update) on the destination table doesn't work anymore. It give no error, and
SELECT statement gives no result.

But if I refresh the page and let it run thru the process again, it executes
the DTS the 2nd timen, and the subsequent SQL query does produce result, BUT
using the destination table produced during the 1st DTS run and BEFORE the
second DTS execution!!!

This is like the 1st DTS execution has not completed when query is executed
on the table? I did do Uninitialize and set Nothing to the "DTS.Package"
object.

Anyone has idea? Please help1