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?

score 0 · Answer 1 · answered Dec 27 '11 at 21:13

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!

score 0 · Answer 2 · edited Jun 21 '17 at 22:03

0

SQL Server 2008 – MUST INSTALL IN THIS ORDER

Install the DTS Designer Components (this must be installed first so that the correct system PATH is configured correctly)

If Windows 8 – must install .NET 3.5 components via Programs & Features
Install SQL Server 2008 client tools (complete)
Install SQL Server 2005 Backwards Compatibility Pack
Replace the stardds.dll file

edited Jun 21 '17 at 22:03

chicks

3,793
10
27
36

answered Jun 21 '17 at 21:24

user421488

1

6 years later I don't have access to this project anymore. Heck, I don't even remember it. :) But if someone can confirm that they were getting the same error message I was getting and this answer solves it I'll happily mark this as the accepted answer. – Brad Dean Jun 23 '17 at 00:16

Can't Open SQL DTS Packages

2 Answers2

SQL Server 2008 – MUST INSTALL IN THIS ORDER