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
 DTS Import/Export Failure

Author  Topic 

aazdoud
Starting Member

1 Post

Posted - 2007-01-12 : 04:51:39
Hello,

I have some problems to import Data from Database from SQL7 to

SQL2000.

The option of copy :- Copy Tables and views from the source database.

- All tables are selected
I run immediately the task. After it fails to copy some tabes (57/129).

Could you please let me know what can cause this problems ?

Thanks in advance.

aazdoud

madhuotp
Yak Posting Veteran

78 Posts

Posted - 2007-01-12 : 06:15:34
what is the error u gets ? pse be descriptive regarding u r problem to get a better solution.
Go to Top of Page

a4nsd
Starting Member

20 Posts

Posted - 2007-01-12 : 23:32:17
You must delete some users in your database source or create some users with the same name in database source.

Hope that it's help you
Go to Top of Page
   

- Advertisement -