Solved

DTS Designer Error

Posted on 2002-07-24
6
302 Views
Last Modified: 2013-11-30
I have a problem. When I attempt to open a DTS package from the client machine I get the following error returned

Title: DTS Designer Error

Message : ||||||||

The DTS package runs OK but I cannot create new ones as my task icons are missing.

The error occurs on the Server machine as well, except it returns a message of ????????

Any ideas ?

Environment

CLIENT

SQL Server 2000 Client Tools on NT 4(SP5)

SERVER

SQL Server 2000 on NT 4(SP5)
0
Comment
Question by:oneinarow
  • 2
  • 2
6 Comments
 
LVL 2

Expert Comment

by:PUMASOFT
ID: 7174254
If you right click on the package and select versions - can you open one of the earlier versions ok?
0
 

Author Comment

by:oneinarow
ID: 7174271
No, same error.
0
 
LVL 2

Expert Comment

by:PUMASOFT
ID: 7174298
I suspect some required file used in the designer (probably related to icons) is either missing or corrupt - can you re-install SQL Server in an attempt to get it back?
0
 

Accepted Solution

by:
oneinarow earned 0 total points
ID: 7174370
Thanks for your advice but I managed to resolve it through anothe website. The comcat.dll was a different version than it should have been due to a VB6 configuration issue.

Its' sorted now.


1inarow
0
 

Expert Comment

by:CleanupPing
ID: 9280063
oneinarow:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question