Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We have a SQL 2008 server. When trying to open DTS packages we'd get this error:

"SQL Server 2000 DTS Designer components are required to edit DTS packages."

Installing SQL Server 200 DTS Designed got rid of this error, but now we get this:

"here were errors loading package "C:\Test\BIData.dts": The specified file is not a Package Storage File. (Microsoft.SqlServer.DtsObjectExplorerUI)"

We've tried with a couple DTS packages. Has anyone come across this before?

share|improve this question

I had similar issues when first attempting to maintain DTS packages using the SQL Server 2008 tools (they weren't worth the effort of converting to SSIS, but still necessary for business reasons.)

There are a couple of MSDN articles I found helpful:

Hope this helps!

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.