Load SQL Server 2000 DTS Design Components

Posted on 2009-04-22
Last Modified: 2012-05-06
I've loaded the SQL Server 2005 Backward Compatibility pack and the 2000 DTS Design Components, but I still get an error when trying to open a DTS package within SQL Server 2008 Management Studio. The error text is below.

TITLE: Object Explorer

SQL Server 2000 DTS Designer components are required to edit DTS packages. Install the special Web download, "SQL Server 2000 DTS Designer Components" to use this feature. (Microsoft.SqlServer.DtsObjectExplorerUI)


Question by:bnielsen56
    LVL 3

    Expert Comment

    Not sure what build version of SQL2008 you are on but you may want to install the Service Pack 1 that was released about 2 weeks (if you haven't already). We had a problem initially with the RTM version of SQL2008 where is was not processing our OLAP Cubes successfully and the only fix was to install (at that time) Cumulative Update 1 (CU1) for SQL2008. We are now in the process of upgrading our SQL2008 machines to Service Pack 1 which is a combination of CU1 thru CU3 plus 6 fixes from CU4.

    Accepted Solution

    Thank you for the effort on resolving the issue.  It turned out installing SQL Server 2000 allowed DTS to work within SQL Server 2008.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Suggested Solutions

    Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
    If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now