sql 2000 dts designer in SQL 2005

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Will Byron - 20 Jun 2006 18:14 GMT

I saved some packages as files on a windows 2003 sp1 machine running sql
2000 sp 4

Some of these files were always files some were in the MSDB database
I saved them all as files since I need to run them in a sql 2005
environment.

I downloaaded the sql 2000 dts components web file and also modified the
sqlweb.exe.manifest
as specified in http://support.microsoft.com/?kbid=917406

I still get the error message

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)

when trying to open the packages from the legacy folder in sql 2005

Any assistance would be appreciated
Thanks

Reply to this Message

Otarius - 23 Jun 2006 08:46 GMT

Download and install it and you'll be able to open sql 2000 dts'es from
legacy folder in sql 2005:
http://download.microsoft.com/download/4/4/d/44dbde61-b385-4fc2-a67d-48053b8f9fa
d/sqlserver2005_dts.msi
Source:
http://msdn.microsoft.com/SQL/bi/integration/downloads/default.aspx

>I saved some packages as files on a windows 2003 sp1 machine running sql
>2000 sp 4
[quoted text clipped - 18 lines]
> Any assistance would be appreciated
> Thanks

Reply to this Message