January 26, 2005 at 3:11 am
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
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
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
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