Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

1 Answer

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
add comment

Your Answer

 
discard

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.