I am using DTS from VB6 to transfer a table from an Oracle database into SQL
Server. There are 17 tables, so I am looping to transfer the tables, then I
have to truncate the tables to perform other operation. Somewhere around the
12th table or so, it seems I cannot truncate the table and just get a timeout
error. I am sending a TSQL command through a DAO database object in a
passthrough mode. I am assuming the problem is some sort of lock that DTS
has on the table. In my code I am setting the Package object to nothing
after the transfer is executed.

I have paused my program at that step where it hangs and I cannot perform a
truncate even through Query Analyzer.

Any help would be greatly appreciated.

Thanks in advance,

WayneM