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

    Red face Unanswered: Unexpected Error, DTS copy objects task

    I am trying to do a Copy SQL Server Objects Task to backup a database to anther database in the same sqlserver with a different name. I had scheduled a DTS package as a job to do this which ran perfectly fine from the past 6 months, it just failed and it doesnt run anymore.
    There are no error messages anywhere except that as soon as if fails i get this " [SQL-DMO] Unexpected parameter value or other condition "

    I do know know what happened to it suddenly

    its a SQL server 2000 with SP2.

    Please help!
    Thanks in advance

  2. #2
    Join Date
    Aug 2002
    What are the privileges of SQL Services account used?

    UPgrade to SP3 and execute the task again. BTW did you get the same error when you execute the job manually?
    --Satya SKJ
    Microsoft SQL Server MVP

Posting Permissions

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