Nowadays, SQL Server 2000 DTS is deprecated. If you try to open a DTS using SQL Server Management Studio 2005 or 2008 you will get the following 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.
In order to solve this error, you need to download SQL Server 2000 DTS Designer componets from https://www.microsoft.com/en-US/download/details.aspx?id=11988. After clicking Download button, you have to choose SQLServer2005_DTS.msi and then click on Next button.
Then, double click on SQLServer2005_DTS.msi and follow the steps to install SQL Server 2000 DTS Designer Components. Finally, you will be able to open DTS files using SQL Server Management Studio, both 2005 and 2008.
If you keep getting the same error, most likely you need to turn off DEP (Data Execution Prevention) for your SQL Server Management Studio. For that, go to System Propeties of your computer, and click on Settings button of Advanced tab in the group Performance.
Then, add your SQL Server Management Studio like in the following image
Sorry, the comment form is closed at this time.