Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 using DTS to import data doesn t refresh the DB

Author  Topic 

rtutus
Aged Yak Warrior

522 Posts

Posted - 2006-07-19 : 12:46:42
1/ When I uise Entreparise Manager DTS to import a table from another SQL server instance, the transaction goes well but I don t see the result in my destination DB in Entreprise Manager right away. Even when I refresh using F5, i don t see the imported table. Usually, I have to restart Entreprise Manger in order to see the new imported table.
2/ Also the DTS impiorts the table but gives it the name: Result. Is that normal, why doesn t DTS leave it with its real name as in the source DB.
Thank you.
   

- Advertisement -