Saving DTS Package

• Simon Baldwin

  SSC Rookie

  Points: 25

  More actions

  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?

   

   

   

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  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

• Simon Baldwin

  SSC Rookie

  Points: 25

  More actions

  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

• Simon Baldwin

  SSC Rookie

  Points: 25

  More actions

  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