SQL Server 2000 DTS Designer components are required to edit DTS packages Error even after installing sqlserver2005_dts.msi

5 pts.
Tags:
SQL Server 2000
SQL Server 2000 to SQL Server 2005 upgrade
SQL Server 2005
SQL Server Upgrade
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following