beckettassociates
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\Prof ile
The default value should be:
%vsspv_visualstudio_dir%\S ettings\Cu rrentSetti ngs-<Date> .vssetting s
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
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
The default value should be:
%vsspv_visualstudio_dir%\S
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
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.
i have installed, repaired, uninstalled, reinstalled several times.
>>it does not recognize that it has been installed.<<
How do you know that?
How do you know that?
In other words, what makes you think that it is not installed?
ASKER
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?
ASKER
yes i do. a picture is attached
legacy.bmp
legacy.bmp
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I have no idea what happened here or how this is going to help future readers of this thread.
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