Post reply

Saving DTS Package

  • January 26, 2005 at 3:11 am

    #163173

    When I try to save a new DTS package on a recently created server using SQLServer 2000 I get the following Package Error:

    Error Source:Microsoft OLE DB Provider for SQL Server

    Error Description: Invalid column name 'packagetype'

    I am able to execute the packages without any problem, I just can't save them.

    I can also create and save packages on other servers without any trouble.

    How stupid am I being?

     

     

     

  • January 27, 2005 at 1:20 pm

    #539422

    Packagetype is a column in the sysdtspackages table in msdb.  Since you say it's a new SQL Server installation, maybe the service packs aren't up to date or it didn't install correctly.  I tried searching the MS Knowledgebase and couldn't find that error.

    Greg

    Greg

  • January 28, 2005 at 12:37 am

    #539474

    Thanks for the pointer, Greg. I'll let my DBA know what you suggest and update my query accordingly.

    Thanks also to all those who have taken the trouble to have a look at my problem - it's reassuring to know that we techies support each other where and when we can.

     

    Simon

  • January 31, 2005 at 4:21 am

    #539703

    Dear All,

    It turns out that this problem was caused by the loss(somehow) of one of the DTS package tables. As it was a new server build, we have been able to re-install SQL server 2000 - all's now well.

    Thanks to those who tried to help.

     

    Simon

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

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