Link to home
Start Free TrialLog in
Avatar of beckettassociates
beckettassociatesFlag for United States of America

asked on

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
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

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 
Avatar of beckettassociates

ASKER

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.
>>it does not recognize that it has been installed.<<
How do you know that?
In other words, what makes you think that it is not installed?
i have installed it several times..
Unfortunately, that is not good enough.  Let me make it simple: Do you have a Legacy object melow the Management object in SSMS?
yes i do. a picture is attached
legacy.bmp
ASKER CERTIFIED SOLUTION
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I have no idea what happened here or how this is going to help future readers of this thread.