 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / DB Engine / SQL Server / July 2008DTS Tool - SQL 2005 upgrade
Any one not been able to install the Microsoft SQL Server 2000 DTS Designer Components? (SQLserver2005_DTS.msi) I can’t find the answer on the web, so I’m turning to you guys. I’m testing the upgrade to SQL 2005, and we have about a dozen DTS packages. None of them real complicated, mostly just data warehouse loads from one database to another. I’m putting the client tools and such on my local PC, and can’t get the DTS tool to install. I just get “The System administrator has set policies to prevent this installation.” I’ve tried as a domain admin, local adim, local user. Checked all the stuff with Group Policy, both local and domain, and can’t find an answer. I still have the SQL 2000 client tools installed, if that makes a difference. Thanks in advance. Jeff I have installed this component many times. It breaks down SQL Server 2000 EM but after installing SP4 everything is working. > I still have the SQL 2000 client tools installed, if that makes a > difference. The point is to open/edit/debug DTS packages via SSMS > Any one not been able to install the Microsoft SQL Server 2000 DTS > Designer [quoted text clipped - 18 lines] > > Thanks in advance. Thanks. I understand the 'point' is to open/edit/debug is SSIS. My point is I can't because it won't install the DTS Designer component. > Jeff > I have installed this component many times. It breaks down SQL Server 2000 [quoted text clipped - 27 lines] > > > > Thanks in advance. Jeff Have you tried Windows Installer Cleanup Utility? Some corrupt information in the registry?? > Thanks. I understand the 'point' is to open/edit/debug is SSIS. My point > is [quoted text clipped - 35 lines] >> > >> > Thanks in advance. Yes, I have. Tried everything I could find doing a search on the web yesterday and still haven't found a solution. I uninstalled the SQL 2000 client tools this morning thinking maybe that was it but it still won't install. > Jeff > Have you tried Windows Installer Cleanup Utility? [quoted text clipped - 39 lines] > >> > > >> > Thanks in advance. > Any one not been able to install the Microsoft SQL Server 2000 DTS Designer > Components? (SQLserver2005_DTS.msi) I can’t find the answer on the web, so [quoted text clipped - 12 lines] > > Thanks in advance. I don't know if this applies to your situation, but check password policy. I couldn't upgrade from SS2000 to SS2005 because one of the scripts has a hard-coded "Yukon90_" password in it and my company has policy of minimum length of 10 characters. Has something to do with SS2005 self-certifying something in msdb with encryption by password. Supposedly SP2 has the same issue. We temporarily removed password policy and upgrade and SP2 went without a hitch. I don't know if the problem exists with the designer components because I also installed that while the password policy was not in force. Ed |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.