Improve company productivity with a Business Account.Sign Up

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

DTS Legacy Password Problem

I am in the process of migrating SQL 2005 to a new Server. I have moved all the databases and moved the Legacy DTS Packages. In the near future I will set up SSIS Packages (as I develop my skill with SSIS). A couple of weeks back I tested the Legacy DTS and it required a password to open the package. That was OK (not desired). However now when I try to open the package I get an error stating that "SQL 2000 Designer componets are required" Can anyone tell me what I may need to do, or didn't do?
Thank You
0
SeTech
Asked:
SeTech
  • 2
1 Solution
 
Anthony PerkinsCommented:
Install the DTS Components for backward compatibility, pehaps.
0
 
SeTechAuthor Commented:
May have to do that, however just last week I was having no problems.
0
 
Anthony PerkinsCommented:
Unless you have installed the DTS Components you will not be able to view or modify any DTS Package. Period.

See here (it is for SQL Server 2008, but the information is the same for 2005):
How to: Install Support for Data Transformation Services Packages
http://msdn.microsoft.com/en-us/library/ms143755.aspx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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