Migration from DTS to SSIS

If you have some DTS packages that you wish to migrate, so that you can make use of it in SSIS, you might want to check out the Package Migration Wizard.

http://msdn2.microsoft.com/en-us/
library/ms143496(SQL.90).aspx

Note that it is not a 100% migration, since not all SQL Server 2000 tasks have a straightforward mapping to SSIS.

You can also try to make use of the Execute DTS 2000 Package Task which allows you to execute SQL Server 2000 DTS packages.
http://msdn2.microsoft.com/en-US/library/ms137907.aspx

If the tasks is relatively straightfoward to migrate, a suggestion is to redo it in SSIS, and make use of the SSIS constructs. Nothing beats the having it run as true-blue SSIS tasks!