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

    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 05:10. Reason: Immediate help required

  2. #2
    Join Date
    Sep 2003
    Location
    Vietnam
    Posts
    10

    Re : DTS package

    Hello,

    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
  •