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)
Read the complete post at http://sqlserver-qa.net/blogs/tools/archive/2007/10/10/sql-server-dts-dynamically-change-source-and-destination-in-transform-data-task.aspx