SQL Server DTS to SSIS

DTS is deprecated from SQL server 2008.
To migrate DTS to SSIS
1. Install Windows server 2003
2. Install SQL Server 2000 and SQL Server 2000 SP3
3. Install SQL Server 2008 R2
ed2k://%7Cfile%7Ccn_sql_server_2008_r2_enterprise_x86_x64_ia64_dvd_522233.iso%7C4662884352%7C1DB025218B01B48C6B76D6D88630F541%7C/
4. Install SQLServer2005_BC.msi and SQLServer2005_DTS.msi
https://www.microsoft.com/zh-cn/download/details.aspx?id=24793
        Verify DTS file can be opened from SQL Server 2008 R2
5. Run the migration wizard from SQL Server 2008 R2
6. Use Dts.Events.FireInformation or Dts.Log for the log/output messages, or use MessageBox.show... Console.writeLine wont'work.

For SSIS development, set ProtectionLevel to EncryptSensitiveWithPassword, and provide/remember the password. The default EncryptSensitiveWithUserKey would have problem for the deployment.

https://msdn.microsoft.com/en-us/library/bb500440(v=sql.105).aspx
https://msdn.microsoft.com/en-us/library/ms143496(v=sql.105).aspx

todo

Check the latest index date and compare with the latest date in the index data file, clear

Check the reason not executed