SqlServer-QA.net
I found this useful blog SQL Server DTS: Dynamically Change Source and Destination in Transform Data