sql dts database duplicate fails


hey all, i have operative problem while common google searches aiding :(



i have prolongation database sql 2000. i wish duplicate over tip training database modernise it. i wish something scheduled occur once week keep training database up-to-date.



i have dts office combined doing this. within dts office i have unparalleled "copy sql server objects" task. assign set adult to:




  • create copied objects


    • drop finish objects first


  • copy data


    • replace existent data


  • copy indexes, triggers, primary unfamiliar keys

  • copy user tables, views, functions stored procedures.



when i run dts package (in pre-production contrast course) gets 99% finished throws following error:



step blunder source: microsoft sql-dmo (odbc sqlstate: 42s02)
step blunder description:[microsoft][odbc sql server driver][sql server]invalid vigilant name 'dbo.vwestassetstationaddress'.
step blunder code: 800400d0
step blunder assistance file:sqldmo80.hlp
step blunder assistance context id:1131


my searches net didn't yield many help. there reports errors removing hit, nonetheless zero seem review circumstances. idea i found the sysdepends list spin corrupted, origination dts office run the scripts wrong order. howeever, i ran following book repremand list still throws same error:



use master
go
alter database [database name]
set single_user
go

use [database name]
go

dbcc checktable('sysdepends',repair_rebuild )
go

use master
go
alter database [database name]
set multi_user
go


i have also seen carrying opposite vigilant owners means error. nonetheless i have reliable objects owned dbo user case.



any suggestions?



Comments

Popular posts from this blog

list macos calm editors formula editors

how hibernate @any-related annotations?

using mvc, should hoop communication between views? between models?