Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2005

    Unanswered: Copy SQL Server Objects - strange behavior

    I'm a wee bit of a newbie concerning DTS and have inherited a db with a DTS containing a Copy SQL Server Objects task set to run nightly. Essentially, it does an informal backup of some core data.

    Recently, I was notified that one of the tables it copies over is now empty on the Destination db. The DTS shows that it runs successfully with no errors logged, the table in question IS selected to be copied from the Source database, there IS data in the Source database table, and every other table in the Destination database is populated appropriately.

    Any ideas on what would cause this one table to be empty without generating any errors?

    FYI, running SQL Server 2000.

  2. #2
    Join Date
    Jan 2007
    Provided Answers: 12
    Copy Object...

    table = object
    records = data

    Alternatively there is a filter clause somewhere (e.g. WHERE user='georgev') that results in no records being added.
    Home | Blog

Posting Permissions

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