how can i open dts files on sql server 2019

Question

I am performing a system upgrade function of a software that has been operating for a long time on sql server 2008 and has dts files.

Now I want to upgrade to 2019?

What function do I have to implement:

I no longer see files to download Microsoft SQL Server 2000 DTS Designer Components and SQL Server 2005 Backward Compatibility Components

I need advice from you guys

Answer 1

I no longer see files to download Microsoft SQL Server 2000 DTS Designer Components

That's quit right, even because that is out-of-support since a very long this.

DTS was supported in BIDS 2005 and BIDS 2008 was the last version. It's no longer possible to edit old DTS packages, you have to recreate them using current SSDT tool.

https://learn.microsoft.com/en-us/sql/ssdt/sql-server-data-tools?view=sql-server-ver16

Answer 2

Hi @Nguyen Van Tien，

To use the DTS files, you may need to upgrade the Integration Services.

When you upgrade an instance of SQL Server 2008 (10.0.x) to the current release of SQL Server, your existing SQL Server 2008 Integration Services (SSIS) packages are not automatically upgraded to the package format that the current release SQL Server Integration Services uses. You will have to select an upgrade method and manually upgrade your packages.

Please refer to Upgrade Integration Services Packages

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.