Can't Open SQL DTS Packages

Question

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?

Answer 1

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:

• How to: Install Support for Data Transformation Services Packages contains all the steps needed to get DTS Designer working in the SQL Server 2008 management tools
• Support for SQL Server 2000 DTS in SQL Server 2008 R2 is a good general overview of considerations for managing DTS packages in SQL Server 2008.

Hope this helps!