Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2009

    Question Unanswered: Please help with DTS package

    Hi all,

    I have tables ( 3 tables) in "A" database and I want to move these tables to database "B". Both the databases are in same server. And also I want to schedule the task as these 3 tables are daily updated and I want updated tables in "B" database.

    I have tried with export/import functionality and created DTS package but I am able to just copy table structures only.
    Also, I am using sqlserver2000

    please help!!!!
    Last edited by sejal; 09-05-09 at 04:10. Reason: Immediate help required

  2. #2
    Join Date
    Sep 2003

    Re : DTS package


    Why do you using mirror function in sql2000, with fully functions such as schedule, which columns.... to other database in the same server or other server.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts