?
Solved

DTS Designer Error

Posted on 2002-07-24
6
Medium Priority
?
305 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Get MySQL database support online, now!

At Percona’s web store you can order your MySQL database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card.

Question has a verified solution.

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

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

762 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