asked on

Error opening DTS Package in SQL 2008 SSMS

I have a SQL 2008 Standard Edition SP1 SQL server running on Windows XP. I have installed both the SQL 2005 Backwards Compatibility pack (SQLServer2005_BC.msi) and the SQL Server 2005 DTS Designer Components (SQLServer2005_DTS.msi). When I try to open a SQL Server 2000 DTS package that has been saved to the SQL 2008 SQL Server, I receive The following errors: Package Error: The DTS Host failed to load or save the package properly. <click on OK> The selected package cannot be opened. The DTS designer has been closed <click on OK> SQL Server 2000 DTS Designer componets are required to edit DTS Packages. Install the special Web download," SQL Server 2000 DTS Designer Components" to use this feature. (Microsoft.SqlServer.DtsObjectExplorerUI).
<click OK> The package opens, but my source and target icons are not present.

Any thoughts or comments?

Reza Rad

the error message is obvious , try install this: SQL Server 2000 DTS Designer Components

aiopsit

ASKER

The SQL Server 2000 DTS Designer Components WERE installed

deepajannu

Can you convert your DTS package to SSIS package as DTS package has got tranformed to SSIS package after 2005 onwards.

Reza Rad

try workaround section in this link:
http://support.microsoft.com/kb/917406

aiopsit

ASKER

We will eventually convert to SSIS In the meantime, our plan is to continue using DTS.

Regarding KB917406, Method 1 did not work.

I will try method 2.

Thank you

Reza Rad

let me know the result,
Regards,

aiopsit

ASKER

No luck with Method 2. I had problems opening the Enterprise Manager.
I am un-installing the SQL 2000 Client Tools.

This KB article is for SQL 2005. I'm running SQL 2008.

ASKER CERTIFIED SOLUTION

Reza Rad

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

aiopsit

ASKER

The first article seemed to do the trick.

I still received the error, but the packed opened. There were no connection objects visible. When i hovered over the area where a connection object was supposed to be, the object became visible.
The connection object was just a "box", but all the properties were there. I had to click on OK for each connection object, and save the package with a new name. I was able to open/run the new package.without making any additional changes.

BTW - I was able to run the initial packages via DTSRUN without making any changes.

Looks like the problem is solved!

Thank you.

Reza Rad

Glad to help,
Thank you for feedback
Regards,