Upgrade SQL Server 2000 DTS Packages to Integration Services Packages

Upgrade SQL Server 2000 DTS Packages to Integration Services Packages

1.Business Intelligence Development Studio (BIDS) - Migrate DTS 2000 Package Wizard

Upgrade SQL Server DTS Packages to Integration Services Packages

https://www.mssqltips.com/sqlservertip/1224/upgrade-sql-server-dts-packages-to-integration-services-packages/

2.SQL Server Management Studio (SSMS) 2008 R2 - 

01.SSMS 2008 R2, connect to SQL Server 2008 R2

02.Management \ Legacy \ Data Transformation Services > right click > Migration Wizard

使用「封裝移轉精靈(Package Migration Wizard)」來移轉 DTS 2000 封裝檔案，以 SQL Server 2008 R2 x64 版本為例

https://sharedderrick.blogspot.com/2011/05/package-migration-wizard-dts-2000-sql.html

PS.若要使用「封裝移轉精靈(Package Migration Wizard)」，需要先安裝「SQL Server 2005 回溯相容性元件(SQL Server 2005 Backward Compatibility Components)

並非所有封裝都可以完全移轉。

例如，有些 DTS 工作不會對應至 Integration Services 工作、自訂工作無法移轉，而 ActiveX Script 工作或資料轉換中的某些指令碼也無法移轉。

Migrating Data Transformation Services Packages

https://learn.microsoft.com/zh-tw/previous-versions/sql/sql-server-2008-r2/ms143501(v=sql.105)?redirectedfrom=MSDN