I found this useful blog SQL Server DTS: Dynamically Change Source and Destination in Transform Data Task that I would like to share the users that are sub-merged with DTS tasks.
Read More...
This is the question asked in MSDN forums, using SQLMAINT utility this can be achieved and also the output can be sent to a text file or HTML file. In case if the steps are defined in the DTS package then its best to use DTEXEC utility. Best to refer
Read More...