DTS packages not recognised in SQL Management studio

So i have the sql management studio. my sqldmo problems are fixed.

i get this...

i have gone to the microsoft link and downloaded the file several times. i hav installed, repaired, uninstalled and re-installed the sqlserver2005_dts.msi, several times. and it just does not recognize that it is there.

i fixed my previous sqldmo problem with the following solution...

I believe that the settings file is usually located here:
C:\Documents and Settings\<Username> \My Documents\SQL Server Management Studio\Settings

The location of what that path is,  is stored in the Registry:

HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\90\Tools\Shell\Profile

The default value should be:

but you can change it to a local path on your harddrive if for some reason the Visual Studio Dir is on a fileshare.

You might be able to find more info through google:

after this fix my sqldmo error went away and nor the dts package isnt recognized.

thanks for any help
Who is Participating?
Anthony PerkinsConnect With a Mentor Commented:
Then I am afraid I have no idea.
Anthony PerkinsCommented:
The message is pretty clear. You need to:
Install the special Web download, "Microsoft SQL Server 2000 DTS Designer Components" to use this feature.

See here:
Feature Pack for Microsoft SQL Server 2005 - November 2005
beckettassociatesAuthor Commented:
And my message above is pretty clear that i have done that several times and it does not recognize that it has been installed.

i have installed, repaired, uninstalled, reinstalled several times.
A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Anthony PerkinsCommented:
>>it does not recognize that it has been installed.<<
How do you know that?
Anthony PerkinsCommented:
In other words, what makes you think that it is not installed?
beckettassociatesAuthor Commented:
i have installed it several times..
Anthony PerkinsCommented:
Unfortunately, that is not good enough.  Let me make it simple: Do you have a Legacy object melow the Management object in SSMS?
beckettassociatesAuthor Commented:
yes i do. a picture is attached
Anthony PerkinsCommented:
I have no idea what happened here or how this is going to help future readers of this thread.
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.

All Courses

From novice to tech pro — start learning today.