DTS Designer Error

  • Can someone please help! When I go into design view of a DTS package, a window pops up and in the title of this message box, it says "DTS Designer Error" - the message inside the box is just a bunch of little squares. I click OK and go into the package, but I have no Tasks. So far I have tried to uninstall SQL 2000, reboot and reinstall. I have also reran 2.6 MDAC upgrade - and I still have this problem.

    Any help would be great, thanks!

  • Did you try opening it up from another computer (i.e. another Client Tools installation)? If so, how are your msdb backups? I can't think of anything other than a restore of the msdb to get them back if you can't open the package from anywhere.

    May be worth a call to MS if it is critical.

    Hopefully someone else can give you a better solution.

    David

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply