View Single Post
  #5 (permalink)  
Old January 21st, 2005, 09:27 AM
rweide rweide is offline
Authorized User
Join Date: Sep 2004
Location: , , USA.
Posts: 70
Thanks: 0
Thanked 0 Times in 0 Posts

After the DTS execution, I use "SELECT COUNT(*) row FROM tbl_Destination" currently. But I also tried @@rowcount and a couple of different variations - thinking maybe I missed something.

Since I also do "Delete from tbl_Destination" BEFORE the DTS to clear the table, so I tried do the delete AFTER DTS to see if the same stored procedure works.

So basically this is what's happening at the moment - Delete and checking row counts on destination table all work fine before the DTS execution, but the same stored procedure or query don't give error and don't give results either after I run DTS.

It's like the destination table has not been released?!

Reply With Quote