We are deploying a new MS SQL 2008 R2 x64 server running on Win 2008 R2 x64. We need to open DTS packages but receive the error:
"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."
I spent all day yesterday googling and following every answer I could find including: installing and re-installing the MS SQL Server Backward Compatibility Components (SQLServer2005_BC.msi) and the DTS runtime components (SQLServer2005_DTS.msi), following carefully to modify the PATH variable, copying various DLL files between MSSQL folders, etc. I cannot seem to get it working.
Has anyone come up against this too and know of something else I can try?