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
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 DTS Import / Export - Failed to copy objects.

Author  Topic 

azmi
Starting Member

37 Posts

Posted - 2006-08-03 : 02:22:34
Hi all,

I got a problem here, when I want to do an DTS/Import Wizard databases from development database to (local) the system show an error message showing 'failed to copy objects from Microsoft SQL Server to Microsoft SQL Server'. Any idea about this message. Thanks..

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-08-04 : 05:07:13
Do you have appropriate right and permissions on the databases?


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2006-08-04 : 07:43:35
Is the sql server agent running on both servers? And does the error message say anything more than this?

--
Lumbago
"Real programmers don't document, if it was hard to write it should be hard to understand"
Go to Top of Page
   

- Advertisement -