dowload SQLServer2005_DTS.msi

Question

Can someone help on how to locate and download SQLServer2005_DTS.msi .Microsoft is not supporting that component download anymore. I need that component to open DTS packages in 2008 SSMS.

Answer 1

Hi @Bandaru, Jaya ,

SQL Server 2005 is out of support for a long time, so I’m afraid it is difficult to find the download address.
As an alternative, you can run the DTS packages in SSIS. Integration Services provides the Execute DTS 2000 Package task for running DTS packages within an Integration Services package.
Please refer to How to: Add Integration Services to an Existing Instance of SQL Server 2005 and Migrating SQL Server 2000 DTS Packages which might help.
In addition, the lack of support means your databases might be vulnerable to security attacks that have been addressed by recent upgrades. It is recommended to upgrade SQL Server 2005 to the latest version.

Best Regards,
Amelia

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

@AmeliaGu-MSFT Thanks for the reply. I got following error when trying to migrate one of the dts package. Any help to troubleshoot this error is greatly appreciated.

---

This wizard will close because it encountered the following error:

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.SqlServer.Management.UI.WizardFrameworkErrorSR&EvtID=UncaughtException&LinkId=20476

------------------------------

ADDITIONAL INFORMATION:

Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index (mscorlib)

---

Answer 3

Hi @Bandaru, Jaya ,

Thanks for reply.
It may because some characters (including the underscore "_") or a space before or after the name of the package which cause the migration wizard to fail.
Please refer to this thread which might help.
And for more question about ssis, you can open a new thread with the sql-server-integration-services tag.

Best Regards,
Amelia

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.