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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!