[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 311
  • Last Modified:

DTS Designer Error

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
oneinarow
Asked:
oneinarow
  • 2
  • 2
1 Solution
 
PUMASOFTCommented:
If you right click on the package and select versions - can you open one of the earlier versions ok?
0
 
oneinarowAuthor Commented:
No, same error.
0
 
PUMASOFTCommented:
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
 
oneinarowAuthor Commented:
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
 
CleanupPingCommented:
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now