Archive databases using DTS ?

[fredong]

Hi,

I need to archive weekly data from AA server archive database to BB server archive database. I need to do a rowcount on AA server archive database of that week and insert into BB server archive database. Before the insert I want to compare the rowcount between these 2 servers and if is equal I want to commit the insert in BB server archive database and delete it on AA server archive database of that week. The DTS will create on BB server and currently I do not have remote linked server to AA server just SQL server connection. What is the best way to do it. Please advise. Thanks.

 

[JayKusch]

How many rows are we talking about. In otherwords, what is the average number of records you have per week?

Thanks

J. Kusch

 

[fredong]

At least 5000 rows.