SQL Server 2000 DTS Designer components are required to edit DTS packages Error even after installing sqlserver2005_dts.msi
Hi,
I am new to Database Technology and was asked to upgrade from MS SQL Server 2000 to 2005.
I followed the procedure regarding the upgration found in one of the posts.THe Upgrade advisor says "SQL Server 2000 DTS Designer components are required to edit DTS packages" and In how to resolve this we were asked to install "sqlserver2005_dts.msi" but even after instaling it and running the upgrade advisor it shows the same error.
I also got the error "SQL Server 2000 Meta Data Services packages are not supported".In order to fix this error, It had something to do with using the Enterprise Manager but i am not able to open it.It shows an error " The procedure entry point could not be located in DLL SEMSFC.DLL
Can you please help me in this regard,on how to go about these errors.
Thank You,
Swetha.
Software/Hardware used:
Software/Hardware used:
ASKED:
December 2, 2008 2:24 PM
UPDATED:
December 2, 2008 4:52 PM
RELATED QUESTIONS
- Trouble with SQL Server 2005 Upgrade Advisor when trying to detect an instance
- SQL Server 2005 Upgrade Advisor in a cluster/SAN environment
- Error in the installation of SQL Server 2005 (64-bit)
- Looking for best approach to upgrade SQL Server 2000 databases to SQL Server 2005
- Database Tuning Advisor "not permitted" error on SQL Server 2005 DE
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
