[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

DTS Designer Error

Posted on 2002-07-24
6
Medium Priority
?
309 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
5 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Suggested Courses

872 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