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/downlo...er2005_dts.msi
Source:
http://msdn.microsoft.com/SQL/bi/int...s/default.aspx
"Will Byron" <will@maxq.com> wrote in message
news:eQBDfxIlGHA.1244@TK2MSFTNGP05.phx.gbl...
>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
>
>