working with DTS packages in sql server.  7.0, 2000, 2005.   

2008:  Data Transformation Services (DTS) has been replaced by SQL Server Integration Services.

SQL Server 2008 Setup does not install DTS support. For more information about DTS functionality in SQL Server 2008, see http://technet.microsoft.com/en-us/library/bb500440.aspx. For information about how to install DTS functionality, see http://technet.microsoft.com/en-us/library/ms143755.aspx

following is a list of system procedures and tables that can be used to work with DTS packages.

TABLES: sysdtscategories, sysdtspackagelog, sysdtspackages, sysdtssteplog, sysdtstasklog

PROCEDURES: sp_add_dtscategory, sp_add_dtspackage, sp_drop_dtscategory, sp_drop_dtspackage, sp_dump_dtslog_all, sp_dump_dtspackagelog, sp_dump_dtssteplog, sp_dump_dtstasklog, sp_enum_dtscategories, sp_enum_dtspackagelog, sp_enum_dtspackages, sp_enum_dtssteplog, sp_enum_dtstasklog, sp_get_dtspackage, sp_get_dtsversion, sp_log_dtspackage_begin, sp_log_dtspackage_end, sp_log_dtsstep_begin, sp_log_dtsstep_end, sp_log_dtstask, sp_make_dtspackagename, sp_modify_dtscategory, sp_reassign_dtspackagecategory, sp_reassign_dtspackageowner