We have a SQL 2008 server. When trying to open DTS packages we'd get this error:
"SQL Server 2000 DTS Designer components are required to edit DTS packages."
Installing SQL Server 200 DTS Designed got rid of this error, but now we get this:
"here were errors loading package "C:\Test\BIData.dts": The specified file is not a Package Storage File. (Microsoft.SqlServer.DtsObjectExplorerUI)"
We've tried with a couple DTS packages. Has anyone come across this before?