Post reply

DTS Package unable to drop table??

  • July 28, 2004 at 6:29 am

    #85904

     Hi there,

    I've created a DTS package to copy 1 database to another and scheduled it as a job. However, it keeps failing on the same task with the error message...

    "Cannot drop table [tablename] because it does not exist in the system catalog"

    The package is designed to drop/create and copy tables and data for each table in the database and all the other tables are being dropped/recreated etc. successfully. This table was recently created and is updated using trigger.

    Can anyone help a confused newbie??

     

    Apologies if its glaringly obvious!

  • July 28, 2004 at 10:22 am

    #516608

    Try this Knowledgebase article.  It contains a workaround.

    Greg

    Greg

  • July 28, 2004 at 2:14 pm

    #516660

    Thanks for the reply!

    Which KB article are you referring to?

    Thanks again

  • July 28, 2004 at 3:20 pm

    #516666

    I sure thought I pasted the url.  Oh well, here it is:

    http://support.microsoft.com/default.aspx?scid=kb;en-us;827448&Product=sql2k

    Greg

    Greg

  • August 2, 2004 at 1:44 am

    #517186

    Thanks Greg

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply