View Single Post
  #1 (permalink)  
Old January 20th, 2005, 02:29 PM
rweide rweide is offline
Authorized User
Join Date: Sep 2004
Location: , , USA.
Posts: 70
Thanks: 0
Thanked 0 Times in 0 Posts
Default Right after DTS, query doesn't work anymore?!

Hi, all,

Please confirm if this is true.

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

However, this execution of the simple SQL query inside the ASP doesn't seem to be working anymore after the run of DTS?!

I use the same query before the table clearing and DTS execution, and it returns the correct row count.

Does this happen to you?

Reply With Quote