Export Object Data Failing In DTS

[lambic]

Hi,

In SQL server 2000 - I'm attempting to copy data from tables in database A to database B. Database B is an exact copy of database A and is on the same server.
However, if I use the DTS Import/Export Wizard, choosing 'Copy objects and data..' and 'Copy data - replace existing data' the copy fails with 'Table does not exist in database'. The table does exist in the destination database, so I'm not sure why it would fail?
Would anybody have any ideas?

 

[SQLDenis]

Is create destination objects checked?

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[lambic]

Hi,

No, I haven't checked that option. I just tried the export with it checked, but it failed with a 'failed to set user permission' error.
Basically I just want to copy the data into a replica database on a weekly basis, for reporting purposes. I'm not using the SQL replication function as I only have the one server. I'm not sure I've chosen the best method to achieve this though!