problem to open SQL server 2000 DTS on SSMS 2008

Question

problem to open SQL server 2000 DTS on SSMS 2008

Shivrudra

SSCrazy

Points: 2835
More actions
January 7, 2010 at 4:08 am

#386054

Hi all
i have done all the necessary steps to open the DTS package (created in SQL server 2000) in sql server 2008 by http://msdn.microsoft.com/en-us/library/ms143755.aspx this help but still i m getting the error 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)
------------------------------
BUTTONS:
OK
------------------------------
please help
Regards,
Shivrudra W

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 1

shivrudra_2008 (1/7/2010)
Hi all
i have done all the necessary steps to open the DTS package (created in SQL server 2000) in sql server 2008 by http://msdn.microsoft.com/en-us/library/ms143755.aspx this help but still i m getting the error 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)
------------------------------
BUTTONS:
OK
------------------------------
please help

Hi,

Check the following link this may be help for u.

http://sqlblogcasts.com/blogs/ssqanet/archive/2009/02/11/error-sql-server-2000-dts-designer-components-are-required-to-edit-dts-packages-microsoft-sqlserver-dtsobjectexplorerui.aspx

Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/