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:
%vsspv_visualstudio_dir%\Settings\CurrentSettings-<Date>.vssettings

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:
http://www.google.com/search?hl=en&rlz=1C1GGLS_en-USUS292US303&q=HKEY_CURRENT_USER\Software\Microsoft\Microsoft+SQL+Server\90\Tools\Shell\Profile&btnG=Search



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

thanks for any help
error.bmp
beckettassociatesAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
http://www.microsoft.com/downloads/details.aspx?FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&DisplayLang=en 
0
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.
0
Anthony PerkinsCommented:
>>it does not recognize that it has been installed.<<
How do you know that?
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

Anthony PerkinsCommented:
In other words, what makes you think that it is not installed?
0
beckettassociatesAuthor Commented:
i have installed it several times..
0
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?
0
beckettassociatesAuthor Commented:
yes i do. a picture is attached
legacy.bmp
0
Anthony PerkinsCommented:
Then I am afraid I have no idea.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Anthony PerkinsCommented:
I have no idea what happened here or how this is going to help future readers of this thread.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.